Forum Discussion
Dataset contains a dynamic data source
Hi Anonymous ,
Thank you for the update.This error usually happens when you connect to a data source using a dynamically generated url.
Power BI blocks combining data from different sources with incompatible privacy levels for security reasons. When you dynamically construct a URL, Power BI cannot determine the privacy level of the resulting full URL, and it defaults to treating it as a combined source. If the root/base URL is set to a different privacy level than the dynamic part (e.g., parameter or other data source), it triggers a “Formula.Firewall” error or credential error.
Closing this dialog and going back to the Query Editor, if you click the Edit Credentials button, you can set credentials for the data source (anonymous access is fine in this case). For more information, please refer to: Chris Webb's BI Blog: Credentials, Data Privacy Settings And Data Sources In Power Query/Power BI
Please refer to these articles, might hold some useful tips:
http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra E.
Hi Anonymous ,
Thanks for the reply.
The core reason you're encountering this issue when publishing to Power BI Service is due to Power BI Service's strict limitations on dynamic data sources.
This is known as a dynamic data source, because the actual database being queried depends on a value evaluated at runtime.
In Power BI Desktop, this is allowed because everything runs locally and interactively. But in Power BI Service, it’s different, the Power BI Service pre-validates all data sources when publishing or refreshing.
In most cases, Power BI semantic models that use dynamic data sources can't be refreshed in the Power BI service. There are a few exceptions in which dynamic data sources can be refreshed in the Power BI service, such as when using the RelativePath and Query options with the Web.Contents M function. Queries that reference Power Query parameters can also be refreshed.
To determine whether your dynamic data source can be refreshed, open the Data source settings dialog in Power Query Editor, and then select Data sources in current file. In the window that appears, look for the warning message, as shown in the following image:
If that warning is present in the Data source settings dialog that appears, then a dynamic data source that can't be refreshed in the Power BI service is present.
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra E.
Thanks for the explanation. We receive this warning indeed. Do you have any suggestions how to fix this?
Regards,
Fleur
Hi Anonymous ,
Thank you for the update.This error usually happens when you connect to a data source using a dynamically generated url.
Power BI blocks combining data from different sources with incompatible privacy levels for security reasons. When you dynamically construct a URL, Power BI cannot determine the privacy level of the resulting full URL, and it defaults to treating it as a combined source. If the root/base URL is set to a different privacy level than the dynamic part (e.g., parameter or other data source), it triggers a “Formula.Firewall” error or credential error.
Closing this dialog and going back to the Query Editor, if you click the Edit Credentials button, you can set credentials for the data source (anonymous access is fine in this case). For more information, please refer to: Chris Webb's BI Blog: Credentials, Data Privacy Settings And Data Sources In Power Query/Power BI
Please refer to these articles, might hold some useful tips:
http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra E.