Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Power Query
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 6

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

 

  • Ashu_Mahadikar Profile Picture
    6 on at
    Re: Unable to link google sheets with excel using power query/get data

    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

  • Ashu_Mahadikar Profile Picture
    6 on at
    Re: Unable to link google sheets with excel using power query/get data
    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

  • Ashu_Mahadikar Profile Picture
    6 on at
    Re: Unable to link google sheets with excel using power query/get data

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Power Query

#1
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 7

#3
SD-13050734-0 Profile Picture

SD-13050734-0 6

Overall leaderboard

Featured topics