The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
#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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.