Forum Discussion

powerbidev123's avatar
powerbidev123
Icon for Solution Sage rankSolution 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.

krishnakanth240's avatar
krishnakanth240
Icon for Super User rankSuper User
1 month ago

Hi powerbidev123 

Can you try these 

1.In Power BI Desktop, File - Options - Data source settings, delete SharePoint entry not just global permissions, also clear cached credentials in Windows Credential Manager for SharePoint entries since PBI Desktop can hold tokens outside in-app permissions 

2.Check whether your org provides conditional access. MFA, device compliance, session timeout on SharePoint is policy change which is  most common cause. Ask your admin if anything changed recently for MFA policy 

3.Try authenticating from different browser since a corrupted browser auth cache for login.microsoftonline.com is a frequent cause