Forum Discussion

SyedAli's avatar
SyedAli
Frequent Visitor
6 years ago

Aggregations not working with Date Table when using Azure SQL Data Warehouse

Hi,   I am trying to build an aggregation table which can work along side with Direct Query using Azure SQL Data Warehouse as source. The same logic worked well when I used source as Sparks.   H...
Need Help
v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi SyedAli ,

 

The aggregated table can be created in the data source with T-SQL queries, or in Power Query, or anywhere else that you can create a grouped table.

 

You can learn more :

https://radacad.com/power-bi-aggregation-step-1-create-the-aggregated-table,

https://radacad.com/power-bi-aggregations-step-3-configure-aggregation-functions-and-test-aggregations-in-action,

https://docs.microsoft.com/en-us/power-bi/desktop-aggregations

 

Best Regards,

Amy

 

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

SyedAli's avatar
SyedAli
Frequent Visitor
6 years ago

Hi v-xicai ,

 

Thanks for your response, I am able to create the aggregations without any issues.

 

What I am experirencing is when I used DATE Table to get the count it is converting treating it as DirectQuery instead of pointing to aggregated table.

 

Thanks