Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all so I'm trying to use the new preview feature for the Dynamic M query feature for direct query. I'm connected to a standard SQL database.
I've got two parameters created as datetime parameters. One for StartDate and one for EndDate. I then use the parameters in my SQL query for my direct query tables that I've created in Power Query. Again this is linked to a standard SQL database. I set some default dates for the StartDate and EndDate parameters just to make sure they work in my SQL query tables using Direct Query and they do work and can load fine.
I then loaded the data and then created two additional tables with date dimensions. One is called the StartDateTable and one is called the EndDateTable. The DAX is below as a example for the StartDateTable. It's exactly the same for the EndDate table:
StartDateTable = CALENDAR (DATE(2021,1,1), DATE(2023,12,31))
Afterwards I then bound the two date columns from my tables to the parameter:
This all works fine but when I started to add two single select slicers for the two date tables bound to the two parameters I'm getting the below error:
Why is this not working? Is it the data source? Like a standard SQL server does not work for Dynamic M queries? It works with the static default values I set for the paremeter but not when I bind a datetime table to the parameter?
Thanks for the quick reply.
So basically this new feature is about as useful as a fly/insect screen on a submarine....
EDIT:
So I created a new idea for the new feature. If forum members could please upvote this, that would be great. At this point this feature is basically useless. There's more data sources it doesn't support than ones it does and also some of the most common data sources most organisations use.
https://ideas.powerbi.com/ideas/idea/?ideaid=cd687a81-75b4-eb11-89ee-0003ff454c66
Solved! Go to Solution.
Hi @Mike282 ,
Please check whether it hit any limitation in this offical documentation:
The feature is only supported for M based data sources. The following DirectQuery sources are not supported:
Best Regards
Hi @Mike282 ,
Please check whether it hit any limitation in this offical documentation:
The feature is only supported for M based data sources. The following DirectQuery sources are not supported:
Best Regards
Thanks for the quick reply.
So basically this new feature is about as useful as a fly/insect screen on a submarine....
EDIT:
So I created a new idea for the new feature. If forum members could please upvote this, that would be great. At this point this feature is basically useless. There's more data sources it doesn't support than ones it does and also some of the most common data sources most organisations use.
https://ideas.powerbi.com/ideas/idea/?ideaid=cd687a81-75b4-eb11-89ee-0003ff454c66
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |