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

Super User
Super User

@Danielnir , What is the refresh time/frequency of google Sheets? make sure there should some ideal time when power bi can read


if the financial function is a Rest API , you can call in power bi


Rest API

Hi @amitchandak 


thanks for the quick reply. Worked like a charm.

Helpful resources

T-Shirt Design Challenge 2023

Power BI T-Shirt Design Challenge 2023

Submit your creative T-shirt design ideas starting March 7 through March 21, 2023.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors