Forum Discussion

ecamci's avatar
ecamci
Regular Visitor
3 years ago
Solved

Google Sheets connector missing (Ver. March 2023)

Hi all,

 

I've been using Power BI for the past two months. In one PBIX file I have set up a few queries to Google Sheets using Power BI's GoogleSheets.Contents formula. I can refresh this file just fine.

 

I installed Power BI on two different devices and opened the same PBIX file. Refreshing didn't work because Google Sheets connector was missing on both devices' fresh Power BI installs:

All three devices have the same Power BI version from March 2023. Did Microsoft silently delete the feature from new versions? How can I install this on the other two devices?

 

Thanks

 

Need Help
  • ecamci's avatar
    ecamci
    3 years ago

    Found it. My solution for this was to open:

    C:\Users\{username}\Microsoft\Power BI Desktop Store App\CertifiedExtensions

    and copy GoogleSheets.pqx from there to other PCs, into the same folder.

1 Reply

  • ecamci's avatar
    ecamci
    Regular Visitor
    3 years ago

    Found it. My solution for this was to open:

    C:\Users\{username}\Microsoft\Power BI Desktop Store App\CertifiedExtensions

    and copy GoogleSheets.pqx from there to other PCs, into the same folder.