Forum Discussion
Does Power BI fully support Azure SQL Data Warehouse?
Hello Power BI seems to work in a way that means it cannot get the best out of Azure SQL Data Warehouse - more specifically Power BI seems likely to generate unnecessary data movement between the...
Just in case anyone else is encoutering the problem above, the recently added COMBINEVALUES() function helps in the above scenario. Details already blogged at:
https://www.sqlbi.com/articles/using-combinevalues-to-optimize-directquery-performance