Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi all,
Hoping someone might have some insight or recommendations for our issue. Details below, please help.
We have a recent issue where the dataflows/reports in PBI Service that query data from folders of Excel files on OneDrive/SharePoint are returning errors of "invalid credentials."
In PBI Serivce, the query can access the source folder and bring in the file records (first 3 steps in image below).
The issue occurs in the 4th step when the query tries to navigate to the specific file. We get the error in the yellow box and then try to "Configure Connection".
The credentials show as anonymous and when we change it to Microsoft Account and OAuth, the error persists. Notably, the Sharepoint address shown in the msg box is not at the folder level, rather, it references the file from the navigation step. (Duno if that is correct or relevant to the issue.)
If we copy and paste the exact same query into PBI Desktop, the query returns the Excel file without issue.
Thing we've tried:
1. Tried to refresh other reports/dataflows that query other ODB/Sharepoint folders, not just the one shown here, issue persists.
2. Tried to change owner of the dataflow to other colleagues and have them input their credentials and refresh. Issue persists.
3. Tried to create a completely new dataflow and query sharepoint folders and encounter same issue.
Any help is appreciated. Thanks!
Hello @Doodle ,
I have same issue from two weeks. Is you problem solved?
Can you please share with me the solution in brief please?
Use OAuth
Use API 14 instead of 15
Use Sharepoint.Contents() instead of Sharepoint.Files()
Clear permissions and reauthenticate.
Thank you very much for quick reply @lbendlin . I sgined out andssigned in back. Do you mean that? If not could you please tell me how to clear permissions in dataflow . I donot see any option here besides to cancel and go back to initial page.
there are a couple of ways to do that but starting over is the fastest, unfortunately.
Is this on-premise sharepoint or sharepoint online?
Its online Sharepoint.
I tried to create new dataflow and updated API and sharepoint.files(). But I do not see table. there was no change. So I addded Imported csv step in script.
Now it show this error.
The screenshot is blurry.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
31 | |
26 | |
23 | |
20 | |
16 |
User | Count |
---|---|
56 | |
38 | |
28 | |
24 | |
21 |