Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Error while trying to import data from Google Sheets onto Power BI Desktop

I am unable to import data from google sheets onto Power BI Desktop. The error that's showing up is "Failed to get contents from link". I had earleir imported few tables from the same link and now wh...
Need Help
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, Anonymous 

I am not sure whether you already did the below step.

Please try the below.

 

In Google Sheet, Go to "File" menu, and you can find the option "Publish to the web".

Here, you can get the link.

 

I hope it helps.

 

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Jihwan_Kim

     

    Yes, I have done that step and I had also pasted the sheets link from the same place on PBI dekstop. No idea why the error is recurring and what's the solution for the issue.

     

    Thanks for the reply