Forum Discussion

tobias29's avatar
tobias29
Frequent Visitor
6 months ago
Solved

Authentication and Query issues - cannot authenticate, queries hang

I have a report that's been causing me issues for weeks. It's massive and has lots of queries with fairly complex operations, so always takes hours to work on.  I'm trying to publish a fix in one of ...
Need Help
  • Mauro89's avatar
    Mauro89
    6 months ago

    Hi tobias29, 

    have you tried to start with a new report and a blank query to isolate the issue. By this you can check if the issue is on the Sharepoint Auth itself or not. From there you can dig deeper in troubleshooting.

     

    Possible next checks:

     

    • Clear Power BI Desktop credential cache: File → Options → Data source settings → Clear all cached credentials, then restart Desktop
    • Use Organizational account authentication instead of Windows credentials when the prompt appears
    • Try authenticating with anonymous first, then switch back to organizational (forces credential refresh)
    • Sign out and sign back into Power BI Desktop completely
    • Check if corporate VPN or firewall settings changed (blocking OAuth endpoints)
    • Try from a different network (home WiFi vs office network)

       

       

    Best regards!

    PS: If you find this post helpful consider leaving kudos or mark it as solution

v-dineshya's avatar
v-dineshya
Community Support
6 months ago

Hi tobias29 ,

Thank you for reaching out to the Microsoft Community Forum.

 

Hi Mauro89 , Thank you for your prompt response.

 

Hi tobias29 , In addition to Mauro89  response, i have added some points.

 

1. Switch to system browser auth: In File --> Options and settings --> Options --> Security, check Use my default web browser. If it’s already checked and you use Edge, temporarily set Chrome or vice‑versa as your OS default browser and retry.

2. Re‑connect using the SharePoint connector:
Get Data --> SharePoint Folder --> Site URL = https://company.sharepoint.com/teams/myteam --> Connect --> Organizational account --> Sign in and apply at the organizational/site level.

3. Please try below M code.

let
SiteUrl = "https://company.sharepoint.com/teams/myteam",
Source = SharePoint.Files(SiteUrl, [ApiVersion = "Auto"]),
Folder = "https://company.sharepoint.com/teams/myteam/Shared Documents/the/desired/folder/",
Filtered= Table.SelectRows(Source, each Text.StartsWith([Folder Path], Folder)),
// keep only required columns to reduce payload
Kept = Table.SelectColumns(Filtered, {"Folder Path","Name","Content"})
in
Kept

4. Target a single file via SharePoint.Contents:

let
SiteUrl = "https://company.sharepoint.com/teams/myteam/",
FilePath = "Shared Documents/the/desired/folder/YourFile.xlsx",
FileBin = SharePoint.Contents(SiteUrl){[Name="YourFile.xlsx", FolderPath=SiteUrl & "Shared Documents/the/desired/folder/"]}[Content],
Excel = Excel.Workbook(FileBin, null, true)
in
Excel

 

I hope this information helps. Please do let us know if you have any further queries.

 

Regards,

Dinesh

  • v-dineshya's avatar
    v-dineshya
    Community Support
    6 months ago

    Hi tobias29 ,

    We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

     

    Regards,

    Dinesh