cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Unable to refresh the model because it references an unsupported data source.

Hi,

 

I created a PBIX file using powerbi desktop. it contains 

  • 18 queries using the Web.Contents source (querying anonymously an online REST API)
  • 1 query using the "Enter Data" feature - Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText(...

I uploaded this PBIX file and created a dashboard and now I see that it never refreshed because it references an unsupported data source.

 

V50sPIt

 

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 ?

 

6 REPLIES 6
Helper V
Helper V

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:

 

1
2
3
4
5
6
7
8
9
10
11
Web.Contents(
    [
        RelativePath="3/action/package_search",
        Query=
        [
            q="cows",
            rows="20"
        ]
    ]
)
Microsoft
Microsoft

@dsebban,

 

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.
https://docs.microsoft.com/en-us/power-bi/service-admin-troubleshoot-unsupported-data-source-for-ref...

 

Regards,

Charlie Liao

I did and don't understand why it doesn't refresh I'm querying external public sources using anonymous connexion. Please help

@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.

 

Screenshot_1.png

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors