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. As I mentioned earlier, I am using get data in Excel to pull the information from google sheets.
Thanks,
Ashwini
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 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
mmbr1606
9
Super User 2025 Season 1
stampcoin
7
SD-13050734-0
6