Forum Discussion
Issue with Dataflow and Semantic Model Refresh – OAuth Error
Hi! FLB
Can you takeover the DF and edit it and see if all tables are refreshing properly. Also, in source settings try to remove the creds and re-add yours. And then try refreshing the dataflow.
Hi FLB,
If re‑authenticating didn’t solve it, double‑check that the SharePoint URL in your dataflow/dataset is the direct site or file path (for example)
https://tenant.sharepoint.com/sites/YourSite/Shared Documents/File.xlsxAnd not a sharing link with /:x/r/ or ?web=1. Also make sure you’ve updated credentials for both the dataflow and the semantic model, and re‑entered them in the gateway if one is used.
After these changes, run a manual refresh — this usually clears the OAuth error. If it still fails, confirm with your Power BI admin that OAuth2 for SharePoint Online is enabled in tenant settings, as that can also block refresh.
Hii FLB
This OAuth error usually occurs when the SharePoint credentials used by the dataflow/semantic model are no longer valid or the previous owner left the company and their token expired. Go to Dataset/Dataflow >> Settings >> Data source credentials and re-authenticate SharePoint using OAuth >> Organizational account with a valid user that still has access. Also check Gateway settings if a gateway is used. Once credentials are re-entered and permissions confirmed, the refresh error normally resolves.
Thank you for your reply. I tried it as you mentioned, but it´s still not working. I have the same access rights for sharepoint, powerautomate, powerbi, etc. as the previous owner. Is there something else that could fail ?
