Data feed from Google Sheets to Power BI

[Danielnir]

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. 

[amitchandak · Accepted solution]

@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

[Danielnir]

Hi @amitchandak 

thanks for the quick reply. Worked like a charm.