Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Unable to link google sheets with excel using power query/get data

Hello,   I have followed all the steps mentioned for editing the URL link of the google sheets "export?format=xlsx". However, when the navigator window opens, instead of the sheets being displayed...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Ashwini,

 

The first record under the [Children] field is a table, consider adding a deepening step in the advanced editor,like.

let
  Source       = GoogleSheets.Contents("https://docs.google.com/xxxxxxx"), 
  Sheet1_Table = Source{[Kind = "Element", Children = "Table"]}[Children]
in
  Sheet1_Table

 You can also click it directly in the PowerQuery Editor view.

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum