Forum Discussion

Danielnir's avatar
Danielnir
Icon for Helper II rankHelper II
3 years ago
Solved

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 publishe...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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's avatar
    Danielnir
    Icon for Helper II rankHelper II
    3 years ago

    Hi amitchandak 

     

    thanks for the quick reply. Worked like a charm.