Forum Discussion

EloiseJane's avatar
EloiseJane
Frequent Visitor
6 years ago
Solved

Direct Query: Multi query date slicer

Hi   I am just started to meddle with Direct query and a SQL database source. I am pulling in a range of data tables, with a common data structure, but where I seem to be failing is finding a way t...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi EloiseJane ,

It is not supported to create calculated tables in DirectQuery mode. For more limitations, you could reference the document : Modeling limitations .

For your requirement, I think you could Create a date dimension or calendar table in SQL Server and then connect to Power BI to filter all the tables. You can also reference this blog : Create a Dynamic SQL Calendar With DirectQuery Mode in Power BI to have a try.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.