Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone, I have a pretty complicated issue this morning and looking for advice.
Background
Problem
You can't schedule refresh for this dataset because the following data sources currently don't support refresh: Data source for Test Discover Data Sources Query contains unknown funtion name: PQGoogleSpreadsheet.Contents.
Solution
I have... NO IDEA WHAT TO DO! AAAAAH
The things I am thinking of atm;
I have spent a few days researching alternative Private Sheet connections and found a few that I will try out this week, but based on that error message, I am not hopeful 😕 And so I come to petition to you fine folk, masters of the craft!
Do you guys know of any type of solution to this problem?
Hi @StefanM
As you can't make the google sheet public and are unable to connect to it via Web entry in Power BI Desktop, you can consider to create a DSN for your google sheet, then connect to google sheet as an ODBC data source in Power BI Desktop, for more details, please review this blog: https://www.cdata.com/kb/tech/gsheets-odbc-power-bi.rst .
Best Regards
Maggie
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.