Forum Discussion

iegorov553's avatar
iegorov553
Frequent Visitor
9 years ago

Import data from power BI to google spreadsheets

Hello,
How is it possible to do this?

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi  iegorov553,

    Currently, you can connect to files on Google Spreadsheet from Power BI Desktop via Get Data->Web entry. Assume that you connect to a Excel file, open it in Google Spreadsheet, go to File / Publish to Web,  then change the selection from Web Page to Microsoft Excel.  Copy the generated link and input the URL in Get Data->Web Window of Power BI Desktop, then enter your Google account and Password. For more details, please review the following screenshots.



    Thanks,
    Lydia Zhang

    • iegorov553's avatar
      iegorov553
      Frequent Visitor
      9 years ago

      Anonymous,

      Thank you for detailed instructions but this is not what I'm looking for. I need to get data from power BI and copy it to Google spreadsheets, not the other way around.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi iegorov553,

        You can export data from Power BI to CSV or Excel, then upload the csv/excel file to Google spreadsheets.

        Thanks,
        Lydia Zhang