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 everyone,
I'm trying to publish a Power BI report to SharePoint and I'm following the following steps below but getting the following error message - 'We couldn't authenticate with the credentials provided. Please try again'.
I used the URL taken from SharePoint but don't know the steps to fix this.
Can anyone help?
I've the screenshots below:
Solved! Go to Solution.
While inside the "Transform Data" section of Power BI, there is an area that holds the saved credentials to all of your sources. Back out of the "Get Data" screen and locate a button called "Data Source Settings".
If you have already got the sharepoint connection inside one of your queries, it should appear in the "Data sources in current file". If not, select the "global permissions". Locate the entry for your sharepoint source, click on it and you should see a button at the bottom called "Edit Permissions". Update the permissions with a username/password that is authorised for that SharePoint site.
If the sharepoint site is hosted on an internal server, you'll like use "Windows" type credentials. If the SharePoint site is host using SharePoint Online, you'll need to use "Microsoft Account"
While inside the "Transform Data" section of Power BI, there is an area that holds the saved credentials to all of your sources. Back out of the "Get Data" screen and locate a button called "Data Source Settings".
If you have already got the sharepoint connection inside one of your queries, it should appear in the "Data sources in current file". If not, select the "global permissions". Locate the entry for your sharepoint source, click on it and you should see a button at the bottom called "Edit Permissions". Update the permissions with a username/password that is authorised for that SharePoint site.
If the sharepoint site is hosted on an internal server, you'll like use "Windows" type credentials. If the SharePoint site is host using SharePoint Online, you'll need to use "Microsoft Account"
That's great, thank you for your help Ross!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
96 | |
69 | |
44 | |
38 | |
29 |
User | Count |
---|---|
155 | |
91 | |
61 | |
42 | |
42 |