cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Danielnir
Helper II
Helper II

Data feed from Google Sheets to Power BI

Hi, 

 

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. 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

2 REPLIES 2
amitchandak
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
https://community.powerbi.com/t5/Power-Query/Using-a-REST-API-as-a-data-source/td-p/50400
https://www.progress.com/tutorials/odbc/directquery-your-custom-rest-api-in-power-bi
https://zappysys.com/blog/howto-import-json-rest-api-power-bi/
https://www.youtube.com/watch?v=ipI6mrWLQKA

Hi @amitchandak 

 

thanks for the quick reply. Worked like a charm.

Helpful resources

Announcements
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