I created a PBIX file using powerbi desktop. it contains
I uploaded this PBIX file and created a dashboard and now I see that it never refreshed because it references an unsupported data source.
What can I do to identify this unsupported data source ?
The REST API needs an auth token, this auth token is never expiring and is hardcoded in my queries. is that the issue ?
Has any one found a solution to this yet? I am in the same situation, getting my data from a JSON API and unable to schedule data refreshes due to the data source being unsupported. @v-caliao-msft @dsebban @BIsteht
Unable to refresh the model (id=379417) because it references an unsupported data source.
@olimilo I did. Code snippets below. I don't recall exactly where I found the base function. I updated what I found to fit my needs. This hits the Pipedrive Deals endpoint. Function name is GetDeals:
(start as number) as record => let Source = Json.Document( Web.Contents( "https://companydomain.pipedrive.com/v1/deals", [Query = [ start = "" & Number.ToText(start) &"" , limit = "500", api_token = "YOURTOKEN" ]] ) ) in Source
This pulls the records to a staging query where I then just expand the record list and model as needed. No issues since using this approach. Staging query below:
let Source = List.Generate( ()=> [Result= try GetDeals(0) otherwise null, Start = 0], each [Result] <> null, each [Result = try GetDeals([Result][additional_data][pagination][next_start]) otherwise null, Start = [Result][additional_data][pagination][next_start]], each [Result]) in Source
Hope this helps.
Hey @BIsteht, I was able to solve mine by referring to the article here: https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-i...
Basically what I did was separate the Web API's URL between a static URL and a variable URL like below:
You need to compare your data source provider with the list of supported data sources found within Refresh data in Power BI to check if it's a supported datasource. Please refer to the link below to see the details.
@dsebban @v-caliao-msft same issue here. A single API call with token embedded in the URL refreshed fine for months. I added a function to page the API yesterday and now the scheduled refresh fails. I vaguely recall seeing some literature on this issue but cannot find it anywhere.
The other odd thing is that I cannot see ANY of the datasources in the model when I try to review the settings. No Gateway Connection or Datasource Credentials options.
We are excited to announce the Power BI Super Users!
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.