Forum Discussion

powerbidev123's avatar
powerbidev123
Solution Sage
1 month ago
Solved

Authentication issues

I've been dealing with an issue in one of my Power BI reports for the past few weeks, and I'm running out of ideas. The report is very large, with numerous queries and fairly complex transformations...
Need Help
  • rohit1991's avatar
    rohit1991
    1 month ago

    Hii powerbidev123 

     

    The transformation change is not causing this because authentication fails before the query runs. Test the site in a blank PBIX using Get Data > SharePoint Folder, enter only the site URL, and select Organizational account. Clear credential entries for both the SharePoint tenant URL and site URL, then sign out, restart Desktop, and reconnect. If the blank test also fails, ask your Entra administrator to review the sign-in logs and Conditional Access policies; if it works, replace the SharePoint source step in the original report.

Kagiyama_yutaka's avatar
Kagiyama_yutaka
Continued Contributor
1 month ago

The safe step is clearing both the tenant‑root and site‑URL SharePoint credentials in Power BI Desktop and signing in again, and checking the same URL once in a blank PBIX to be sure the creds are clean. Desktop uses the cached tenant‑root OAuth first, so resetting both entries is what stops this sudden auth failure.