cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
iegorov553
Frequent Visitor

Import data from power BI to google spreadsheets

Hello,
How is it possible to do this?

6 REPLIES 6
v-yuezhe-msft
Microsoft
Microsoft

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.

1.PNG2.PNG3.PNG

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-yuezhe-msft,

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.

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-yuezhe-msft

 

But it's becoming a problem when you need to do it hourly

Hi @iegorov553,

Firstly, an idea about automatically exporting data on different time basis has been submitted in this link, please vote it up.

Secondly, to some extent, you can use R script to export data to CSV automatically, please check alanhodgson’s reply about this method in this thread.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
iegorov553
Frequent Visitor

Hello,
How is it possible to do this?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors