Forum Discussion

pswain's avatar
pswain
Helper I
6 years ago

Would like to automate the cloud health data https://apps.cloudhealthtech.com/login in Power BI

Hi All,   Need Community help on this.   We would like to use Cloud health data into Power BI in automation maethod. The data formats of cloud health available are PNG, CSV, send to Google drive....
v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi pswain ,

 

You may choose the option "Send to Google drive", then use Web connector to get data of Google drive, see more details : Connect a Google Sheet spreadsheet to Power BI as a data source. In this way , it needn't to use gateway when publish to Power BI Service, and the data refresh synchronizes datasets and reports in Power BI Service with the underlying data in Google drive.

 

For reference:

 

https://community.powerbi.com/t5/Desktop/How-to-connect-google-sheet-to-Power-BI/td-p/209400

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • pswain's avatar
    pswain
    Helper I
    6 years ago

     

    Hi Amy,

     

    Thank you for reaching out to this. The document which you have shared that was for Google sheet link ( that worked.) , however, when I tried in the same way for Google Drive ( procedure to get the web link to insert in Power Bi web connector ) It didn't work for me.  can you please share the docs or video where I can follow on this.

  • pswain's avatar
    pswain
    Helper I
    6 years ago

    Hi Amy,

     

    Thanks so much for reaching out to me on this. I think I have completed 80 percent of my work. My question is below.

     

    I am connected from the Google sheet to the PowerBI app. Is that Google URL below is a dynamic URL? I mean will we able to get dynamic data into PowerBI?

     

    https://docs.google.com/spreadsheets/d/1H98iYAYcu4S4FshaLJ-eOOzVIGBtMA6SEI3TUHjo5ac/export?format=xlsx&id=1H98iYAYcu4S4FshaLJ-eOOzVIGBtMA6SEI3TUHjo5ac

     

    How can we filter out in URL lets say if we want data for 6 months data, how can we customize this URL.?

     

    I was expecting a Cloud Health URL in Power BI, but this is not...

     

    Kindly help on this.

     

    Please reach out to me on this

    [email protected] 

     

    Regards

    kumar