#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.
DataZoe
on:
Issue with Card Visual Layout After November Power...
on:
Adding a measure or column as a tooltip to an Azur...
parry2k
on:
A Typo about Refence Line in the Format (Korean)