Forum Discussion
Azure Data Warehouse w/ DirectQuery
Hi Anonymous,
I don’t know anecdotaly, about its issues, please post the question in anecdotaly forum to get better support.
Additionally, to improve performance after connecting to Azure Data Warehouse through DirectQuery in Power BI Desktop, I would recommend you review the following articles to optimize Azure data warehouse design.
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-best-practices
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-statistics
Thanks,
Lydia Zhang
Anonymous, i don't mean to be rude, but are you taking the piss w/ the first sentence?
To be clear, I am saying that people have told me that PowerBI working with ADW like-for-like is vastly improved now.
Anyway.. my ADW design is well optimised and I have been working with the product for almost a year now, and we get good results from it, the issues that were faced previously were due to poor query construction from PowerBI.. i don't need anecodtes for this, i know what the behaviour was at the time.
If you are not aware of the specifics of any optimisations that Power BI working with ADW has had, that's fine... but an answer to that question, from people that use these products together is what I'm after.
Ty,
Chris.