Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
We are doing the evaluation of the different ways that we could connect our Synapse (DWH) to Power BI Premium (PPU) and avoid problems with the performance in the future. We want to make sure that we are using the extra features that Power Premium (PPU) offers and the best practices. We are not using AAS.
We would like to know the best practices in terms of type of connection (Import/DirectQuery) and:
- Active Large datasets in Power BI Premium
- Using datasets or dataflows
- Use Normal view or materialised views in the DWH of dimensions
- Use Result-set caching
We know the use of DirectQuery and Normal views is an antipattern according to power-bi-professionals-guide-to-azure-synapse-analytics_2020_06.pdf. We think we should use Materialised Views or Result-set caching. -> What is the recommendation, here?
We were wondering if we use Import as a connection it could be good to use normal views or Materialised Views. We think normal views or a flat table which join the dimensions and fact tables could be fine, because we are going to have the data in the dataset in Power BI -> What is the recommendation, here?
We were wondering when is recommended to use Result-set caching.
We think we are going to datasets. Because we are doing the data preparation in Synapse. Also, dataflows can introduce significant risks to the scalability and sustainability of the solution according to this doc: power-bi-professionals-guide-to-azure-synapse-analytics_2020_06.pdf -> What is the recommendation, here?
Thank you so much!!
Mukhthar
Hi, @MukhtharM
You can refer to the following link, hope it can help you.
https://towardsdatascience.com/azure-synpase-analytics-power-bi-f6ded6f96d5f
https://www.youtube.com/watch?v=vOSzw40TohM
https://docs.microsoft.com/en-us/power-bi/enterprise/service-premium-large-models
These are the documents about connecting Synapse and Power BI.
https://docs.microsoft.com/en-us/azure/synapse-analytics/quickstart-power-bi
https://docs.microsoft.com/en-us/azure/synapse-analytics/get-started-visualize-power-bi
And these are the document about import mode vs direct-query mode.
https://www.tessellationtech.io/import-vs-direct-query-power-bi/
https://docs.microsoft.com/en-us/power-bi/connect-data/service-dataset-modes-understand
https://docs.microsoft.com/en-us/power-bi/guidance/directquery-model-guidance
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.