Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Can't refresh data from public API even it passes the Data Source Credentials.

Hi,   I'm getting producer price index data from a public API. It works fine on power bi desktop and it passes the Data Source Credentials test on the server(See picture below).             ...
PUBLIC API
refresh data
  • aj1973's avatar
    aj1973
    5 years ago

    Hi Anonymous 

    I tried your Query and published it to the service. The refresh is working just fine

     

    How did you configure the source credentials?

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Amine,

Thank you for your reply. I thought the problem was the API, but it turned out to be that my M query was wrong.

Actually, I'm using a query to get a list of seriesid from an Excel file instead of using [""WPU071102"",""WPUID632""] in my M query. I was able to solve the problem by combining two queries and changed the privacy level to "public" for both data sources.

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

You are welcome

kindly Accept this thread as the solution. More people will benefit from it