Forum Discussion
Dataset wants me to edit data source credentials, and at the same time won't let me do that
So I am back again, figured out what caused the problem, I started removing the OneDrive Excel datasource and publishing the report again. After that I could access the part to enter my credentials again and now that is working.
Somehow Onedrive excel brings an issue here, so if anyone has a similar situation, you might want to import your excel into sharepoint, if that is a possibility. I can't to that just yet, I first need to make some big adjustements in Excel that won't be as easy to make in sharepoint, so after the document is completed and no more changes need to be made, I will upload it to Sharepoint and publish my report once again.
I have been making a completely new dataset in PowerB Desktop for this project, and when it was only data from Odata connection, I could manage the dataset credentials. However, after adding Excel from Onedrive and some lists from Sharepoint, the dataset credenitals part is grayed out again.
Seems like I cannot use datasets from different resources in one report? Is that correct?
It does not seem logic to me... What is the best way to handle this?
I searched all topics, but did not find any topic matching mt situation.
I hope someone has some wisdom for me here.
Thank you in advance!
Warmly,
Sabrina