Forum Discussion

mbarragan's avatar
mbarragan
Frequent Visitor
9 years ago

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 P...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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.:smileyhappy: 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's avatar
Krizz83
Regular Visitor
9 years ago

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?

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi Krizz83,

     

    It may be the same issue as I described above. Please vote the idea here.:smileyhappy:

     

    Regards