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 dataset in the published online version but it will not let me, it is greyed out.
This is the query from the desktop:
let
Source = Web.Page(Web.Contents("http://localtimes.info/North_America/United_States/Arizona/Phoenix/")),
Data = Source{1}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data,{{"Column1", type text}, {"Column2", type text}}),
#"Transposed Table" = Table.Transpose(#"Changed Type"),
#"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table", [PromoteAllScalars=true]),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"Current local time:", type time}, {"Date:", type date}, {"Time zone:", type text}, {"Current time zone offset:", type text}, {"Twitter Share", type text}}),
#"Added Custom" = Table.AddColumn(#"Changed Type1", "Custom", each [#"Date:"] & [#"Current local time:"]),
#"Changed Type2" = Table.TransformColumnTypes(#"Added Custom",{{"Custom", type datetime}})
in
#"Changed Type2"And this is a screenshot of the greyed out Data Source Credentials:
Why can't I schedule this to refresh??
24 Replies
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 :-).
Hi Bezos,
By my tests, if you install the Data gateway(personal mode) and edit the credential with Anonymous, then you could set up the schedule refresh.
Best Regards,
Cherry
So if I install the personal gateway, the report will refresh, but only if my laptop is powered on. So this is not a solution afterall :(
hi, did you find the solution?
I'm facing the same problem. My data are located in my Sharepoint environement, and I don't want to use a gateway (Thank you IT guy)
How to refresh my reports?
Excellent!!!!! thanks a lot for your reccomendations 👍
Hi, for me the issue was that although my main query took data from sharepoint, I had another query drawing data from a seperate local source, so I had to remove/workaround this. Worth checking!
Thanks! This turned out to be my issue. Crazy that something so little caused it.
I'm facing the exact same issue, and have tried the solutions provided by amazing helpers in the comments (thanks!) but no luck.
- I can't install personal gateways due to company laptop's restriction
- All data sources on Sharepoint Online (not on premise, and no local files)
Not sure if there is any more solutions on this issue? Thanks in advance everyone!
Thank you for your responses. Why does this code require a Gateway to be installed? Is there a way to allow the code to be refreshed without a gateway? I don't know if using the gateway is an option, as my computer is not always powered on.
I would like this to work without a gateway. I have a separate query that uses an excel file from sharepoint to create a report. This query refreshes automatically with some Sharepoint magic. Then, when I added the query above to the original query to get the time, it wouldn't let me automatically refresh with the Sharepoint magic. Does that make sense?
So is there a way to have the two queries together so that they both refresh automatically?
Thanks.
Hi Bezos,
Actually, we don't need to configure the date gateway as your data source is online.
For online source, it will refresh automatically.
However, if you want to set schedule refresh, you should set the data gateway. You could install your gateway in a server always online.
Best Regards,
Cherry
I'm actually unable to refresh the entire data set. This is what happens when I try and manually refresh the data from the workbook -> refresh now:This was my original question, why am I unable to refresh this data set?
In my case after I reselect the gateway, the problem was solved.
I found solution for me.
I had the same issue. In my case, I was REPLACING the dataset and the report on service.
After a while I deleted the dataset on service and then I published again.
Problem solved, than I was able to edit credentials.Sadly, I lost many users metrics. That is the hardest part of story. But the main problem was solved.
Regards
