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!
The source is a data source with a web url api.
I have to call on it in a way similar to this "www.datasource.com/api/KPI1&KPI2&KPI3/Project=_______"
I then have a list of project names as a separate source (sharepoint file) and a column is added to that table which runs the column ProjectName against inside that URL.
Because of that query which requires dynamic parameters, when I refresh the data on Desktop, there's no problem. However when I publish and then run a refresh of the data set from the service, I get "Unable to refresh the model (id=10889070) because it references an unsupported data source."
I know that function isn't possible with Power BI yet so I'm trying to see if running either a Data Gateway or AAS model would solve the issue.
Regarding the ODBC connection, I don't think that applies here given the API call being a web url.
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.