Forum Discussion

dylanndengu's avatar
dylanndengu
Helper I
5 years ago

DAX Equations with DirectQuery

Hi Everyone,   I am using DirectQuery to access data in a PostgreSQL database with millions of rows. I'm accessing about 10 different tables and trying to make reports using them. One of them is cu...
General Comment
Need Help
v-xulin-mstf's avatar
v-xulin-mstf
Community Support
5 years ago

Hi dylanndengu,

 

Here is the modeling limitation of DQ.

Although import mode has complete modeling capabilities, it is slow to import data.
You can model in SQL SERVER Analysis Services.
Then Connect to Analysis Services tabular data with Live Connection in Power BI Desktop.

You can refer:

https://docs.microsoft.com/en-us/analysis-services/tutorial-tabular-1400/as-lesson-1-create-a-new-tabular-model-project?view=asallproducts-allversions

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-analysis-services-tabular-data

 

Best Regards,

Link

 

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