Forum Discussion
Multiple credential issue - report connexions to multiple sharepoint subfolders
Hey Anthony_Dest ,
if you publish a Power BI Desktop report to a workspace inside the Power BI workspace, it's important to remember that credentials used for the connection to the data sources will not be published with all the other content. This is due to security and privacy concerns.
For this reason, it is necessary that you authenticate again after you have published your report.
Navigate to the dataset inside the workspace at the Power BI Service:
From here you can navigate to the settings of the dataset using the Schedule refresh icon, check the section Data source credentials:
Maybe you have to re-enter the credentials to authenticate against the SharePoint online site again.
If this does not help you, might consider providing more details on the error message. You will find these detail on the refresh history list, this list is also available on the dataset settings site:
Here you will find a list of the last refreshes of the dataset. If there is an error you can get detailed error information by just click on error.
Hopefully, this provides some ideas on how to tackle your challenge.
Regards,
Tom
Super UserHey Anthony_Dest ,
if you publish a Power BI Desktop report to a workspace inside the Power BI workspace, it's important to remember that credentials used for the connection to the data sources will not be published with all the other content. This is due to security and privacy concerns.
For this reason, it is necessary that you authenticate again after you have published your report.
Navigate to the dataset inside the workspace at the Power BI Service:
From here you can navigate to the settings of the dataset using the Schedule refresh icon, check the section Data source credentials:
Maybe you have to re-enter the credentials to authenticate against the SharePoint online site again.
If this does not help you, might consider providing more details on the error message. You will find these detail on the refresh history list, this list is also available on the dataset settings site:
Here you will find a list of the last refreshes of the dataset. If there is an error you can get detailed error information by just click on error.
Hopefully, this provides some ideas on how to tackle your challenge.
Regards,
Tom
Hi TomMartens and thank you for your answer.
I delayed my answer because, for some reason, I am unable to go into my dataset's settings. When I click on it, nothing happens. Except sometimes when it tries to load but lands on the workspace again. Same thing for the schedule refresh button.
About the credential, I checked them out and re entered them multiple times before. Still getting the same issue.
From memory, it made me log in with my professional account and that was it.
Here are screenshots (sorry, my organisation forces french)
You can here see the first dataset used as a test with no error. The second one with the error. The only difference betwin them is that the second one is bigger and fetches informations in multiple subfolders of the sharepoint.
It says : "Scheduled refresh failed because at least one data source doesn't have credential informations."
I will update this post as soon as I can get into the settings again.
Regards,
Anthony