Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
matteoumbri
Frequent Visitor

Performance for Import + live dataset model

I am building a composite dataset as follows:

- some Dimension tables on import mode

- a HistoryFact table which is a connection to a 1-table Power BI dataset, published on the service with incremental refresh (that's over 80 million rows)

 

Question is about query performances, especially on report pages with many resource-intensive visuals: 

will a report built upon that composite model perform the same, when interacted by an end-user on the service, compared to an identical report, this time built upon a full import-mode dataset? 

I am asking this because on Power BI desktop, while writing measures and testing visuals on pages, I assume it is normal that when you have all the tables loaded on cache locally, visuals load faster than when one of your main tables needs to query the data to the service over the network. 

But when a composite dataset like the one described above is published on the service, well, the whole data is already there on some Azure storage, no queries are sent to the original data sources while the end-user comsumes the report, so I would assume that the experience for the user should be as an import-mode. 

Is that correct? 

Thanks

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

"will a report built upon that composite model perform the same, when interacted by an end-user on the service, compared to an identical report, this time built upon a full import-mode dataset? "

 

Yes. At that point both options are represented as Power BI Service datasets  (as opposed to pass-through Direct Query back to the data source)  so the performance is expected to be identical.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

"will a report built upon that composite model perform the same, when interacted by an end-user on the service, compared to an identical report, this time built upon a full import-mode dataset? "

 

Yes. At that point both options are represented as Power BI Service datasets  (as opposed to pass-through Direct Query back to the data source)  so the performance is expected to be identical.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors