Forum Discussion
Connect google sheet to excel
To my knowledge Google Sheets connector so far doesn't exist for all versions of Power Query. Workaround to connect converted to Excel file is to use ?output=xlsx in UR
let Source = Excel.Workbook( Web.Contents( "https://docs.google.com/spreadsheets/d/1OBoS9Gpi0YMCZT-RZKggEHju3ulDP3CA5me1mmzHRCk/export?output=xlsx&id=1OBoS9Gpi0YMCZT-RZKggEHju3ulDP3CA5me1mmzHRCk" ), null, true), Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data], #"Changed Type with Locale" = Table.TransformColumnTypes( Sheet1_Sheet, {{"Column3", type date}}, "en-US") in #"Changed Type with Locale"
Depends on goals. If to make the choice that's between 2021 (next after 2019 version) and 365. With 2021 you will have available for today functionality, and only this one, for at least another couple of years, till version 2023 or so appears. All updates will be related to bug fixing, performance and like, no new functionality within the version.
365 is updating with new functionality on regular basis, how fast you receive it depends only on distribution channel you select for your subscription (channel could be changed at any time free of charge). Yes, there is difference between subscriptions - Enterprise is the richest one.
You may compare Pro/Business here Office applications service description - Service Descriptions | Microsoft Docs. As I remember among consumer subscriptions Home one has close to Business (not Enterprise) functionality, the only difference in license terms. In brief, you are not allowed to earn money on using Home subscription.
