Forum Discussion
Refresh unsupported source Alternatives
There's been a lot of threads about the dreaded "Unable to refresh the model because it references an unsupported data source" error. I have a query that uses a column in a table as a parameter to be...
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!
GilbertQ
Super User
Super UserWhich data source type are you using to connect to the data?
It's two fold.
The first is using a Web URL (Web connector) which requires a parameter in it. I defined that parameter as "= (ProjectName as text) =>" at the top of the query to turn it into a custom function.
I then use an Excel table hosted on Sharepoint which has a column called ProjectName. I added a colum with the "Invoke Custom Function" option and chose that column (ProjectName) as the parameter by which to run every row against that Custom Function.
Whenever I do a refresh within PBI Desktop, everything works like a charm.