Forum Discussion
Data Source Credentials Greyed out
Hello, I have a simple query that retrieves the time from a website. The query works in Power BI desktop and I can publish it to Power BI online Workspace. I want to be able to refresh the datas...
In my case, I initially used Folder.Files to develop the query and then switched to SharePoint.Files.
After publishing the dataset, I was not able to refresh the data due to greyed out credentials as many others here.
I explored the Power BI file and found that a reference to the original folder location stayed in the Data Source settings:
After finding that reference in a helper query and rewriting it also to Sharepoint, the folder item disappeared - now after publishing, I am able to set up a scheduled refresh, and sit back and relax, while data are moved from cloud to cloud :-).