"This dataset includes a dynamic data source." - Help

Hi Shamatix ,

The reason why Power BI Service does not support this query is security.

1. This way Power BI prevents that someone can inject the loading of unauthorized data by adding a row to a source table from which the dynamic queries are created.
2. Since you load a list of databases dynamically and Power BI Service does manage credentials on database level (not on server level) it does not even know what credentials to ask for when you set up the database connections and credentials for the dataset in Power BI Service. And there is no interaction intended at (manual or scheduled) dataset refresh time for asking for credentials once a new data source appears in your database table.

Power BI Desktop also gives you a security warning and also asks you for credentials, but you can turn off these security warnings completely and once they are confirmed they also do not appear again.

Possible solutions are:

• If your list of databases and tables to load is rather static over time consider implementing static Power Query code that allows Power BI to determine the data sources and credentials at dataset setup time.
• If you want to build a truly metadata driven loading process, consider adding an upstream data warehouse. This is exactly why Power BI advanced to Fabric, since this is a frequent use case for larger or more versatile data projects than within the scope of Power BI Desktop. Alternatively to Fabric, you can use SQL-Server/SSIS on premises or Azure SQL Database/Data Factory as cloud tools to implement your solution.

BR

Martin