Forum Discussion
Not able to save credentials - excel source file in OneDrive
Hi all
I am trying to set up a PowerBi report to automatically refresh. I think I have worked out that it is not working because of credentials. However, when I try to save the credentials, literally nothing happens. I click on 'save' and it looks like the system registers the click but then nothing happens and when I click 'close' it asks me if I want to discard changes.
Pic below. Any ideas?
(I am extremely new to PBI so will need things explained very simply please).
Hi Alex0106 ,
Thanks for reaching out to the Microsoft fabric community forum.Get SharePoint Site and File Path
Open the Excel file in OneDrive for Business in the browser.Click "..." - Details to view the document location.
Copy the full SharePoint URL up to the site root.
Example: https://yourorg.sharepoint.com/sites/YourTeamSite
Use SharePoint Folder in Power BI Desktop
In Power BI Desktop, go to Home - Get Data - More - SharePoint Folder.Enter the root SharePoint URL (like above).
When prompted for credentials:
Choose Organizational account (OAuth2).
Sign in with your work credentials.
Power BI will return all files in the site. Filter by your file name to select your Excel file.
Load the Data
Transform the data using Power Query as needed.Save and publish the report to Power BI Service.
Set Credentials in Power BI Service
Go to Power BI Service - Workspace - Dataset Settings.Under Data source credentials, choose OAuth2 / Organizational account and sign in.
Click Save - it should now work properly since SharePoint Folder supports this flow.
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find itBest Regards,
Sreeteja.
Community Support Team
8 Replies
Hi Alex0106 ,
Can you try changing the authentication method to OAuth2. This should allow you to login with your credentials.If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.
Thanks,Samson
Hi Samson
Unfortunately I have no other options for the Authentication method other than the one selected.
Thanks
Alex
Hi Alex0106 ,
Thanks for reaching out to the Microsoft fabric community forum.Step 1: Use the Web Connector with Direct Download Link to Excel File
The Excel connector often restricts auth options. The Web connector supports OAuth2 and is more flexible with OneDrive/SharePoint Online files.
To do this:Go to your Excel file in OneDrive.
Get the direct download link:
Open the file in OneDrive (in browser).
Click Share - Copy Link (make sure link allows access).
Modify the link to force direct download if needed by replacing
?e=... with ?download=1 or use the OneDrive "Embed" option to extract a direct download URL.
Example-
https://onedrive.live.com/download?resid=FILEID&authkey=AUTHKEY
Open Power BI Desktop.
Choose Get Data > Web.Paste the direct download URL obtained in step 2.
When prompted for authentication in Power BI Desktop, select OAuth2 and sign in with your organizational account.
Load your data and create your report.
Publish the report to Power BI Service.
Configure Credentials in Power BI ServiceGo to Power BI Service > Workspace > Dataset Settings.
Under Data source credentials, click Edit Credentials for your data source.
You should now see OAuth2 as an option select it.
Sign in and save the credentials successfully.
Clean Old Data Source Permissions
In Power BI Desktop, go to File > Options and settings > Data source settings.
Find and clear any existing permissions related to the old Excel or OneDrive source.
Save and republish your report after reconnecting via the Web connector.
Additional Tips:
Use SharePoint URL instead of OneDrive URL if you’re using OneDrive for Business:
OneDrive for Business files are stored in SharePoint. Use the SharePoint site URL and folder path to connect via SharePoint Folder connector or Web connector.Update Power BI Desktop to the latest version to ensure all authentication features are available.
Check with your IT admin if tenant policies restrict authentication flows.
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find itBest Regards,
Sreeteja.
Community Support TeamHi Alex0106 ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.Thank you.
Hi Alex0106 ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solutionand give a 'Kudos'. This will be helpful for other community members who have similar problems to solve it faster.
Hi
Thanks for your response. Unfortunately its still not working.
When I copy the link I can grant access but only to people in my organisation. I can't grant access to anyone who has the link. Could this be the issue?
I also can't find the onedrive embed option in my work onedrive online - I can see it on my personal onedrive files.
Hi Alex0106 ,
Thanks for reaching out to the Microsoft fabric community forum.Get SharePoint Site and File Path
Open the Excel file in OneDrive for Business in the browser.Click "..." - Details to view the document location.
Copy the full SharePoint URL up to the site root.
Example: https://yourorg.sharepoint.com/sites/YourTeamSite
Use SharePoint Folder in Power BI Desktop
In Power BI Desktop, go to Home - Get Data - More - SharePoint Folder.Enter the root SharePoint URL (like above).
When prompted for credentials:
Choose Organizational account (OAuth2).
Sign in with your work credentials.
Power BI will return all files in the site. Filter by your file name to select your Excel file.
Load the Data
Transform the data using Power Query as needed.Save and publish the report to Power BI Service.
Set Credentials in Power BI Service
Go to Power BI Service - Workspace - Dataset Settings.Under Data source credentials, choose OAuth2 / Organizational account and sign in.
Click Save - it should now work properly since SharePoint Folder supports this flow.
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find itBest Regards,
Sreeteja.
Community Support Team
