如何将Google Sheet与Power Bi连接? [英] How to connect google sheet with power bi?
问题描述
我正在尝试使用R Studio将google sheet与power bi连接,youtube上有斯蒂芬妮·洛克(Stephnie Locke)录制的视频,但这只是一小段视频,不能完全帮助您.那里的任何人都可以正确,完全地帮助您.
如果您不仅限于R Studio,还有另一种方法可以从Power BI访问Google表格数据:
样本数据:
- 获取Google表格的可共享链接(权限至少
具有该链接的任何人都可以查看
):
-
修改共享链接并添加以下部分:
发件人:
- 如果您深入到表格"单元格,则应该能够看到数据并从那里开始工作.
I am trying to connect google sheet with power bi using R Studio, there is a video on youtube by stephnie locke, but that is just a short video and dont help completely. any one there which can help properly and completely.
解决方案If you're not limited to R Studio, there is another way to access Google Sheet data from Power BI:
Sample data:
- Get shareable link of the Google Sheet (Permission at least
Anyone with the link can view
):
Modify the shareable link and add the following parts:
From:
https://docs.google.com/spreadsheets/d/google-sheet-guid/edit?usp=sharing
To:
https://docs.google.com/spreadsheets/d/google-sheet-guid/export?format=xlsx&id=google-sheet-guid
e.g.
https://docs.google.com/spreadsheets/d/1ohAz8SD6viEGIrcor-JC-vCt2yRbgY1c-7Uflv-_hrA/edit?usp=sharing -> https://docs.google.com/spreadsheets/d/1ohAz8SD6viEGIrcor-JC-vCt2yRbgY1c-7Uflv-_hrA/export?format=xlsx&id=1ohAz8SD6viEGIrcor-JC-vCt2yRbgY1c-7Uflv-_hrA
Create a blank query in Power BI and get the source as below:
let Source = Excel.Workbook(Web.Contents("the-link-in-step-2"), null, true) in Source
- If you drill into the Table cell you should be able to see the data and work from there.
这篇关于如何将Google Sheet与Power Bi连接?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!