Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Data feed from Google Sheets to Power BI



I made a currency exchange dataset in Google Sheets by using the GoogleFinance function. Dataset is being updated on a daily basis. Whenever I'm trying to update the Power BI report published to the service, that uses this data, I'm receiving an error saying that there are missing columns in the google dataset. The problem lies in the fact that when I'm opening this sheet, all data disappears for a second for the duration of recalculation and then it's reappearing again. So whenever Power BI tries to get the data from this source, It can only see a cell with a "loading" message and therefore shows an error. 


Did anyone had a similar problem and knows how to fix it?


Apologies if the topic is too loosely connect to the Power BI. 

Super User
Super User

Hi @amitchandak 


thanks for the quick reply. Worked like a charm.

Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors