API Connection Won't Authenticate in Power BI Service

Hi sjschminke3 

You can use the example in the link below from Prathy where she explains how to store the token within a single power query table.

Calling Power BI API using Power BI Desktop to document Power BI Service – Prathy's Blog…

Hi sjschminke3 ,

Thanks for GilbertQ reply!

sjschminke3 Based on community experience, there are several approaches for you reference.

• Clear browser cache.
• Select Skip Test Connection when setting up.

• Set up a On-premises data gateway.Install an on-premises data gateway | Microsoft Learn

Here are some links for your reference:

Solved: Credential Error for Excel File hosted on One Driv... - Microsoft Fabric Community

API Unable to refresh in Power BI Service: The cre... - Microsoft Fabric Community

Failed to update data source credentials - Microsoft Fabric Community

Best regards,

Mengmeng Li

In addition to the 2 above responses, I also had to change the data source privacy level to "Organizational" and it finally worked!  Thank you both!