Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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, I get the document and when I click on that there is a weird 2-row table. I have attached the screenshot of the same.
I have checked the community answers as well but nowhere I could get an exact solution.
I have tried all possible solutions but the same issue persists.
Kindly help me with this.
Thank you,
Ashwini
Hi Gao,
The steps you have mentioned are for Power BI.
But I have an issue with Excel.
Hi Gao,
Thank you for the response!
However, I could not quite follow your instructions as I am using this power query to connect Google Sheets to Excel for the first time.
Could you please explain in detail as I was not able to understand where to input the below step you mentioned
Thank you,
Ashwini
Hi @Ashwini,
1. In PowerBI Desktop --> Get data --> choose the google sheets:
2. You'll be prompted for a Google Sheets URL. Copy and paste the URL from your browser address bar into the input prompt.
3. The Google Sheets connector supports connecting through an organizational (Google) account. Select Sign In to continue.
4. Check the workbook you want to import and click Convert Data to enter the PowerQuery Editor.
5. Try clicking Table, when the mouse hovers over it, it has an underline and the font color is different, indicating that it is a container.
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
Hi Gao,
Thank you for the response!
However, I could not quite follow your instructions as I am using this power query to connect Google Sheets to Excel for the first time.
Could you please explain in detail as I was not able to understand where to input the below step you mentioned
Thank you,
Ashwini
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
11 | |
8 | |
8 | |
7 |
User | Count |
---|---|
14 | |
13 | |
9 | |
7 | |
6 |