我正在尝试使用 R Studio 将 google sheet 与 power bi 连接,在 youtube 上有一个由 stephnie locke 制作的视频,但这只是一个简短的视频,并没有完全帮助.任何可以提供适当和完全帮助的人.
解决方案如果你不限于 R Studio,还有另一种方法可以从 Power BI 访问 Google Sheet 数据:
样本数据:
修改分享链接,添加如下部分:
发件人:
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:
Modify the shareable link and add the following parts:
From:
docs.google/spreadsheets/d/google-sheet-guid/edit?usp=sharing
To:
docs.google/spreadsheets/d/google-sheet-guid/export?format=xlsx&id=google-sheet-guid
e.g.
docs.google/spreadsheets/d/1ohAz8SD6viEGIrcor-JC-vCt2yRbgY1c-7Uflv-_hrA/edit?usp=sharing -> docs.google/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
更多推荐
如何将谷歌表格与power bi连接?
发布评论