Forum Discussion
Scheduled refresh greyed out
My report has two data sources (a Google Sheet and a Zoho report). Both are "public" so no permissions are required, only the URL.
Do I even need to schedule a refresh or will it automatically fetch the data and keep my dashboards up to date?
If I need to schedule it, why won't it let me? I read in other posts I might need to re-publish (tried that), or I cannot use two DirectQuery sources, I must use Import. Does this even apply here and where would I make that choice?
Hi Dave,
I really found something. Your URLs are parsed as web contents. So Power BI uses Web.Page() function, which requires a data gateway. Please refer to power-bi/refresh-data#power-bi-desktop-file.
>>>If you are using the Web.Page function, you do need a gateway if you have republished the dataset or your report after November 18th, 2016.
I would suggest you save the Google docs as XLSX format.
Best Regards,
Dale
13 Replies
Hi mr-budd,
Yes, the public data sources don't need any credentials. But we still need to verify it. Please refer to the snapshot below.
Best Regards,
DaleThanks for the reply Dale, v-jiascu-msft. It must be a credentials problem of sorts. Our corporate email has two domains (@pipint.com and @pip.global). It says the dataset was created by my @pip.global account, however the PowerBi account I always use is the @piptin.com. They can't even find my @pip.global address if I try to log in (see second screenshot).
I can only log in with @pipint.com email, and it won't let me edit the "Data source credentials" section, which is probably why the "Scheduled refresh is greyed out"? Is it this separate email that is preventing me from editing?
Hi mr-budd,
You need to choose a gateway first. Then "Data source credentials" option will be highlighting.
Best Regards,
Dale
I have the same issue, my Data Source credentials also greyedout. Help!!!
