Data Source Error - The credentials provided for the Web source are invalid

[matthelee]

Please refer to the screnshots below. My Power BI service has been having this refresh issue since yesterday (5/9 12AM) and I initially thought it was a transient issue. Any help would be appreciated, thank you!

 

[GilbertQ]

Hi @matthelee 

That looks good, but that only checks it can connect, there could be a subsequent issue with the API after the connection?

[matthelee]

Hi @GilbertQ ,

The issue may be because my company is phasing out of using Airtable. However, I checked internally and confirmed that I still have full access. I am continuing to try to solve the problem internally as well, but are there any other solutions you recommend I try?

[GilbertQ]

The only other way I can think of is to try using Postman to see what happens when you connect?

[matthelee]

Hi @GilbertQ ,

I'm not sure if Postman is approved for use by my company, would you be able to explain what it is and what it does? Thank you and I really appreciate your help.

[GilbertQ]

Hi @matthelee 

It allows you to test out your API calls and see how it works and if something is going wrong how to troubleshoot and fix any issues.

[matthelee]

Hi @GilbertQ ,

Thank you for clarifying, I am meeting internally with my team next week and will keep you updated.

[GilbertQ]

Hi @matthelee 

From the error it is saying that it cannot connect to the API. Can you confirm that you can successfully connect to the API via Postman or your application?

[matthelee]

Hi @GilbertQ ,

Yes, as you can see by the screenshot below the API (Airtable) connects. 

Is this a viable solution? -> https://support.airtable.com/docs/visualizing-airtable-records-in-microsoft-power-bi-power-query