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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
aorsgl
Regular Visitor

Why power bi dont support refresh on dynamic data sources

Hi, 

 

Ive seen the documentation and similar questions looking for a solution using relative paths in the web.content.

 

My question is why its not supported? i.e. why shouldnt we be able to refresh a dynamic data source using the Microsoft on-premises data gateway?

 

1 ACCEPTED SOLUTION
Ehren
Employee
Employee

Hi aorsgl. The Power BI service doesn't support refreshing dynamic data sources because of how the service handles Power Query data sources. Unlike PBIDesktop, the PBI service expects to be able to inspect the M statically to determine what data sources are being accessed. It then can prompt you ahead of time for the credentials to use for these statically discovered data sources. However, because it relies on static analysis, it is limited in the kind of data sources it can discover. If it finds a data source function using dynamic expressions it doesn't understand, it blocks refresh of the dataset.

 

PBIDesktop, on the other hand (and PQ in Excel, as well as Power Query Online), prompts for credentials dynamically, as data sources are encountered during evaluation. This means it can handle fully dynamic data sources, since they work just like any other data source from its perspective.

 

Please feel free to vote for (or create) an idea about supporting refresh of dynamic data sources in the PBI service over on the PBI Ideas site.

 

Ehren

View solution in original post

1 REPLY 1
Ehren
Employee
Employee

Hi aorsgl. The Power BI service doesn't support refreshing dynamic data sources because of how the service handles Power Query data sources. Unlike PBIDesktop, the PBI service expects to be able to inspect the M statically to determine what data sources are being accessed. It then can prompt you ahead of time for the credentials to use for these statically discovered data sources. However, because it relies on static analysis, it is limited in the kind of data sources it can discover. If it finds a data source function using dynamic expressions it doesn't understand, it blocks refresh of the dataset.

 

PBIDesktop, on the other hand (and PQ in Excel, as well as Power Query Online), prompts for credentials dynamically, as data sources are encountered during evaluation. This means it can handle fully dynamic data sources, since they work just like any other data source from its perspective.

 

Please feel free to vote for (or create) an idea about supporting refresh of dynamic data sources in the PBI service over on the PBI Ideas site.

 

Ehren

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors