Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I've been looking all over the net and I can't find out how to link a private google sheet to Power BI. There are options to publish the google sheet but because it's an internal data sheet I can't do that. Does anyone else know if there is any other ways to link it beside going through excel? I need it to update the data automaticly instead of me refreshing each day.
Thank you in advance,
Liz
Solved! Go to Solution.
@Anonymous
Refer
https://community.powerbi.com/t5/Power-Query/Connecting-Power-BI-to-Private-Google-Sheet/m-p/199660
https://community.powerbi.com/t5/Power-Query/Connect-to-Google-Sheets/m-p/612193
Vote:
@Anonymous
Refer
https://community.powerbi.com/t5/Power-Query/Connecting-Power-BI-to-Private-Google-Sheet/m-p/199660
https://community.powerbi.com/t5/Power-Query/Connect-to-Google-Sheets/m-p/612193
Vote:
Thank you for much for responding. I've called our IT Team so they can look into this and fingers crossed we can use the Google Sheet ODBC Driver or if they can come up with another solution.
Once I heard from them I'll update you.
Thank you,
Liz
Hi @Anonymous ,
Have you tried this method?
How to connect google sheet with power bi?
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |