In case you are interested, here's my latest blog post on pulling data from Google Sheet using the Sheet API. https://tumbleroad.com/2016/07/07/free-marquee-google-sheets-template/
This would be awesome to have. Although, I am having some difficulty getting things to work.
When following this methodology I am receiving a "Key" and "Column Heading" column with none of my sheets data. Let me know if you have any ideas on how to resolve.
All the best,
Do you know if it is possible to use the Google API credential in the same way to enable access to a published Google Sheet (such as published as a .xlsx). Since you created the tutorial I think they changed the API set up structure so now you cannot select "browser key" this may or may not be why I've been unable to make this work.
I've only been able to get data from unprotected published google sheets so far, so a way to reach protected sheets with a credential would be great improvement.
When using my own spreadsheet and API key (set up using the instructions on your site), I get a "PERMISSION_DENIED" result when accessing the link. I think this is why my data is failing.
However, using your link (the commented out link in the Power BI script) your data and API key are loading the data correctly.
Are there any other settings you made when setting up the API key? That is probably why mine isn't working.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.