Forum Discussion
Automate export to google sheets
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 C
Thank 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 CYes, this works. But then its not automated and thats the whole idea ;)!
I need to automate the export
