Forum Discussion
Automate export to google sheets
I would like to automate the process to get our visualised dashboard data exported to google sheets.
So I can use the data from our backend into our google sheets. At this moment our programmers can push data to powerbi but they dont know how to combine data and I want to visualis the backend data in combination with google sheet data, because of the powerfull functions within sheets.
6 Replies
Hi patrique ,
The easiest way to connect to Google sheet is to Get Data / From Web, then enter the URL to your google sheet, with "&output=xls" on the end, e.g.
You could refer to How to connect google sheet with power bi? for details.
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos CThank you for your fast answer.
Well, I try to get data in googlesheets from the powerbi dashboard but i still puts out a HTML document if I import the url.
I think this solution you offered is the other way around to import data into powerbi.
While I am trying to get data into google sheets.
The solution looks like an import instead of an export of dataHi patrique ,
Thanks for the clarification.
To export data from powerbi you can follow this link : https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-desktop
I am not sure if you could export directly into google sheet but you export in form of excel and then load the excel file into google sheet .
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
Hi Patrique,
Slideform is a new automation tool that can help you out (full disclosure: I'm the co-founder). Slideform integrates with Power BI and can pull the data and charts you've built in Power BI into the office tools that you use everyday, like Google Sheets, Slides, PPT, Word, and Excel. I hope this is helpful and we'd love to have your feedback.
