cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DeniseD
New Member

Power BI Premium (PPU) & Synapse (DWH) - Best practices

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!!

1 REPLY 1
v-jayw-msft
Community Support
Community Support

Hi @DeniseD ,

 

Here are some blogs.

https://towardsdatascience.com/azure-synpase-analytics-power-bi-f6ded6f96d5f 

https://www.youtube.com/watch?v=vOSzw40TohM 

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://community.powerbi.com/t5/Desktop/direct-query-vs-import/m-p/112212 

https://www.tessellationtech.io/import-vs-direct-query-power-bi/ 

Hope these help you.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors