cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mbarragan Frequent Visitor
Frequent Visitor

Power BI Web return Credential Invalid Error on Anonymous Access of API URL.

I've a report that has a dataset composed from differents sources. Five of theses sources are an API that returns a different .CSVs depending on specifics parameters in the URL. When I'm working on PowerBI desktop, the data is loaded successfully, but, when I publish the report and I want to update the data from PowerBI web, a "credential error" happens for the API source.

 

2016-11-30_15h54_34.png

 

2016-11-30_15h58_28.png

 

I noted that this error happens when there are more than one API source...

 

What is the problem?

 

Sincerely,

Marcos.

 

6 REPLIES 6
Microsoft v-ljerr-msft
Microsoft

Re: Power BI Web return Credential Invalid Error on Anonymous Access of API URL.

Hi @mbarragan,

 

Queries where data access happens inside a function and where the data source is dependent on parameters to the function can't currently be refreshed. You can vote the idea here. And here is a similar thread for your reference.Smiley Happy

 

Regards

mbarragan Frequent Visitor
Frequent Visitor

Re: Power BI Web return Credential Invalid Error on Anonymous Access of API URL.

Hi @v-ljerr-msft,

 

I think I've not explained enough. What I wanted to mean was that I have five sources of a only one API, but the final URL of each source is unique, e.g.:

 

Source1 : www.123ExampleApi.com/poweBI?url=source1
Source2 : www.123ExampleApi.com/poweBI?url=source2
Source3 : www.123ExampleApi.com/poweBI?url=source3
Source4 : www.123ExampleApi.com/poweBI?url=source4
Source5 : www.123ExampleApi.com/poweBI?url=source5

 

This is what I wanted to mean with "Five of theses sources are an API that returns a different .CSVs depending on specifics parameters in the URL.". My queries don't access to data inside a function, I've only specified new data sources in the query editor.

 

Thanks and best regards,

Marcos.

Microsoft v-ljerr-msft
Microsoft

Re: Power BI Web return Credential Invalid Error on Anonymous Access of API URL.

Hi @mbarragan,


This is what I wanted to mean with "Five of theses sources are an API that returns a different .CSVs depending on specifics parameters in the URL.". My queries don't access to data inside a function, I've only specified new data sources in the query editor.


Indeed, I knew exactly what you are trying to do.Smiley Happy As you are requesting your server with parameters to get data, there should be a function in your server to accept the parameter, then returns different .CSVs depending on the specific parameter, right? Because Power BI is doing static analysis of the query to discover the data source, and the static analysis can't yet handle this scenario currently.

 

Regards

Krizz83 Frequent Visitor
Frequent Visitor

Re: Power BI Web return Credential Invalid Error on Anonymous Access of API URL.

I have the same problem with an OData source.

First odata source loads fine. Next 3 cannot be updated and gives the error "Failed to update data source credentials.".

 

Any ideas?

Microsoft v-ljerr-msft
Microsoft

Re: Power BI Web return Credential Invalid Error on Anonymous Access of API URL.

Hi @Krizz83,

 

It may be the same issue as I described above. Please vote the idea here.Smiley Happy

 

Regards

mbarragan Frequent Visitor
Frequent Visitor

Re: Power BI Web return Credential Invalid Error on Anonymous Access of API URL.

Hi @v-ljerr-msft,

 

The different sources from Google Storage since the schedule refresh work fine, we've tried to liken the API URLs to the Google Storage URLs:

 

GoogleStorage (works fine):

https://storage.googleapis.com/bucket1/tmp/0009518e.csv
https://storage.googleapis.com/bucket1/tmp/8197581r.csv

 

API - without url parameters (Doesn't work):

https://us-central1-project1.cloudfunctions.net/0009518e
https://us-central1-project1.cloudfunctions.net/8197581r

 

Could you explain why the schedule refresh works fine for the first one way, but for the second one way the credentials error is appeared? Is it due to the second one returns a url redirection to a .csv and the first one it's just a .csv?

 

Thanks and best regards,

Marcos.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors