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

 

 

 

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

 

What is the problem?

 

Sincerely,

Marcos.

 

Need Help

6 Replies

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

    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.:smileyhappy:

     

    Regards

    • mbarragan's avatar
      mbarragan
      Frequent Visitor
      9 years ago

      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.

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Icon for Microsoft Employee rankMicrosoft 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