cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
timsleeper
Frequent Visitor

Data Sources vs Performance Calculation

I have a report with a source not that big (~300-400k rows) but it relies on some pretty heavy calculations (http://community.powerbi.com/t5/Desktop/Pareto-80-20-calculation-taking-too-long/m-p/24255).

 

Up until last week, I had the report built with Power BI desktop with on-premisses data sources and then published to the cloud with the desktop app. Performance was sluggish at best. Then I made a little experiment uploading the data to a Azure SQL Database, set a copy of the report pulling the data from Azure SQL via DirectQuery and then publishing the same way. The performance was way better.

 

My questions is, does moving the data to the cloud and using it as a DirectQuery source improves the general performance of calculations? I thought that all calculations were made on Power BI but if the Power BI + DirectQuery + Azure Cloud combination improves performance, I'll definitely consider hosting some of the data on the cloud.

 

Cheers,

Tim

1 REPLY 1
ankitpatira
Community Champion
Community Champion

@timsleeper It could be more about data retrieval from Azure SQL DB as it stores data across multiple nodes, data retrieval would be better than your on premise data source. 

 

When you had on premise data source with power bi desktop did you use DirectQuery or import then? As I would assume you might experience performance delays in calculations if you were using DirectQuery from powerbi.com to your on-prem data source and then doing calculations on it.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!