Forum Discussion
The data source web is missing credentials
- 1 year ago
Hi AmandaHore ,
Thank you for reaching out to the Microsoft Community Forum.
Please follow below steps:
1. Go to Power BI Service (https://app.powerbi.com/). Find your workspace where you published the report.
Go to: Workspace ➔ Datasets + Dataflows ➔ Find your Dataset ➔ Settings.
2. Under Data source credentials, you should see something like: Web – showing an error (credentials missing).
Click Edit Credentials for the Web source. Set it like this: Authentication method: Organizational Account (NOT anonymous!). Sign in with your Microsoft 365 / SharePoint account. Privacy Level: Organizational (just like in your desktop settings) & Save.
Note:
If you used a SharePoint "browser" link (like the one you copy directly from the address bar), it may not behave perfectly.
For SharePoint Online files, it’s better to use the SharePoint folder connector instead of just "Web."
But what you have can still work with the right authentication.3. Re-authenticate Data Source:
Sometimes, re-authenticating the data source can resolve credential issues. Try unlinking and linking the data source connection again from Power Query > Manage connections .
4. Clear Browser Cache:
Clearing the browser cache can sometimes resolve issues related to credential settings. After clearing the cache, try accessing the Power BI Service again .
5. Create a New Dataflow:
If the issue persists, create a new sample dataflow with the same data source and check if the data source credentials are enabled in the new dataflow's settings.
6. Export and Import Dataflow:
Export the existing dataflow to a Power Query template and import it into a new dataflow. This can sometimes enable the data source credentials in the new dataflow's settings.
7. Check Permissions:
Ensure that the user account used for accessing the SharePoint Online CSV file has the necessary permissions. Verify that the account has read access to the file and is correctly configured in the Power BI Service.
Please refer community threads and official documents.
Solved: Refresh and data source credentials disabled - Microsoft Fabric Community
Solved: Data source extension is missing credentials - Com... - Microsoft Fabric Community
Solved: Power BI is saying my data source is missing crede... - Microsoft Fabric Community
Connect to cloud data sources in the Power BI service - Power BI | Microsoft Learn
Create and share cloud data sources in the Power BI service - Power BI | Microsoft Learn
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank you
Hi AmandaHore ,
Thank you for reaching out to the Microsoft Community Forum.
Please follow below steps:
1. Go to Power BI Service (https://app.powerbi.com/). Find your workspace where you published the report.
Go to: Workspace ➔ Datasets + Dataflows ➔ Find your Dataset ➔ Settings.
2. Under Data source credentials, you should see something like: Web – showing an error (credentials missing).
Click Edit Credentials for the Web source. Set it like this: Authentication method: Organizational Account (NOT anonymous!). Sign in with your Microsoft 365 / SharePoint account. Privacy Level: Organizational (just like in your desktop settings) & Save.
Note:
If you used a SharePoint "browser" link (like the one you copy directly from the address bar), it may not behave perfectly.
For SharePoint Online files, it’s better to use the SharePoint folder connector instead of just "Web."
But what you have can still work with the right authentication.
3. Re-authenticate Data Source:
Sometimes, re-authenticating the data source can resolve credential issues. Try unlinking and linking the data source connection again from Power Query > Manage connections .
4. Clear Browser Cache:
Clearing the browser cache can sometimes resolve issues related to credential settings. After clearing the cache, try accessing the Power BI Service again .
5. Create a New Dataflow:
If the issue persists, create a new sample dataflow with the same data source and check if the data source credentials are enabled in the new dataflow's settings.
6. Export and Import Dataflow:
Export the existing dataflow to a Power Query template and import it into a new dataflow. This can sometimes enable the data source credentials in the new dataflow's settings.
7. Check Permissions:
Ensure that the user account used for accessing the SharePoint Online CSV file has the necessary permissions. Verify that the account has read access to the file and is correctly configured in the Power BI Service.
Please refer community threads and official documents.
Solved: Refresh and data source credentials disabled - Microsoft Fabric Community
Solved: Data source extension is missing credentials - Com... - Microsoft Fabric Community
Solved: Power BI is saying my data source is missing crede... - Microsoft Fabric Community
Connect to cloud data sources in the Power BI service - Power BI | Microsoft Learn
Create and share cloud data sources in the Power BI service - Power BI | Microsoft Learn
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank you