Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello,
I've published a report which I would like to turn on scheduled refresh for.
I only have one data source - Web query - Google Docs.
The problem is that I am forced to use a Data Gateway but I don't understand why.
It won't let me turn on scheduled update if I don't turn on the data gateway. A note is that in the beginning of creating the report I was using an Excel-sheet on my local machine as a data source, though I have removed it from the data source settings and tried republishing I'm still forced to turn on the Gateway. Any idea what this could be?
(Everything works fine when i turn on the data gateway but I would really prefer not to use one)
Do you see the same issue when you start fresh with only the Google Docs data source?
Thanks for your reply! Do you know of any method to relatively quickly transfer the report to a new one? (without having to copy paste all measures, clean data and so on)
That's not the point. You only need to recreate the connection to see if the problem with the gateway persists.