Forum Discussion
Refresh unsupported source Alternatives
I ended up solving the problem by following this blog post and tweaking it
Then I connected it along all my other sources to the Power BI Data Gateway and everything seems to work now!
v-lid-msft I just tried creating a static table with a single project name and Invoking Custom Function as a separate column. I published it and get the exact same error "Data source errorUnable to refresh the model because it references an unsupported data source."
Hi Anonymous ,
Based on this document: https://docs.microsoft.com/en-us/power-bi/refresh-data#review-data-infrastructure-dependencies
Power BI currently does not support parameterized data source definitions, also known as dynamic data sources. For example, you can't parameterize the data access function Sql.Database("SqlServer01", "AdventureWorks"). If your dataset relies on dynamic data sources, Power BI informs you that it detected unknown or unsupported data sources. You must replace the parameters in your data access functions with static values if you want Power BI to be able to identify and connect to the data sources.
Are you using the web connector to connect the web api?
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.