#1 : I have tried various unseccessful attempts to import tables from google sheet, which is created on our organizational/corporate gmail account. (ie it does not work with myname@companyname.com - this is hosted by google). I ma reciving following error message "this datatype is not supported"
#2 : However it works only with personal gmail/google sheet. It works only with myname@gmail.com - which is hosted by google
Following is blank query method, it was succesful with #2 but not with #1
= Excel.Workbook(Web.Contents("https://docs.google.com/spreadsheets/d/GoogleSeetId_Hidden_kKtM0gxx/export?output=xlsx"), null, true)
Please provide solution for this. I need solution to use #1 to build reports using power BI.
v-xiaoyan-msft
on:
Report jumps between two profile logins.
on:
Get External Data: Power BI semantic models throws...
Idrissshatila
on:
Timeline slicer is showing 30 & 31 March under 30 ...