Good day,
I would like to ask if how can I import google sheet to power BI?
For your assistance.
Thank you and God bless,
Christian
Solved! Go to Solution.
The easiest way is to Get Data / From Web, then enter the URL to your google sheet, with "&output=xls" on the end, e.g.
http://spreadsheets.google.com/pub?key=r1hlZB_n1rpXTij11Kw7lTQ&output=xls
PBI then analyses the resulting Excel file, showing the tabs as tables , which you can edit and manipulate.