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?

     

     

     

     

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
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