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

(0) Share

Report

Posted on by Ashu_Mahadikar

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

Categories:

Power Query

Error.png

I have the same question (0)

All responses (3)

Answers (0)

Ashu_Mahadikar 6 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ashu_Mahadikar 6 on at

Like (0)

Report

2 seconds ago
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

Was this reply helpful? Yes No
Ashu_Mahadikar 6 on at

Like (0)

Report

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

Was this reply helpful? Yes No