Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
mr-budd
Frequent Visitor

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?

 

 

image.png

image.png

 

 

 

 

 

 

1 ACCEPTED SOLUTION

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. 

refresh-greyed-out

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

13 REPLIES 13
NLuu
Regular Visitor

I have the same issue, my Data Source credentials also greyedout. Help!!!

v-jiascu-msft
Microsoft Employee
Microsoft Employee

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.

Scheduled_refresh_greyed_out

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks 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?

 

problem1.PNGproblem2.PNG

Hi @mr-budd,

 

You need to choose a gateway first. Then "Data source credentials" option will be highlighting.

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks again Dale.

 

I was hoping there was a way to do it without running a personal gateway on my computer, since the data sources are public (Google, Zoho). But I guess that's not an option?

Hi @mr-budd,

 

How is the dataset created by an account that doesn't exist? Can you share some snapshots like below? It seems they are all connected through Web connector. How did you create it?

Scheduled-refresh-greyed-out2

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-jiascu-msft

Yes they are web connectors. It works now that I am running a personal gateway. See screenshots. They are public URLs where anyone can connect as anonymous. I was hoping there was a way to get the Power BI dashboards to refresh from these data sources without running a gateway service on my laptop.

 

gateway.PNGanonymous-google.PNGanonymous-zoho.PNG

Hi @mr-budd,

 

Since they are all public resource, can you share the links here? Then I can make a test.

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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. 

refresh-greyed-out

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


 Hi v-jiascu-msft
I have the same issue but for a sharepoint site, should I also change it to an excel and how would I go about that?
isThatAFrog_0-1660560399701.png

Thanks @v-jiascu-msft (Dale). It worked! @edhans see below..

 

Capture.PNG

FWIW @mr-budd you now need a gateway for web sources. I believe it was to ensure that only authorized data was being brought into your Power BI Service. I had to add a simple web page into my gateway just to get a DST table.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.