如何将谷歌表格与power bi连接? [英] How to connect google sheet with power bi?

问题描述

我正在尝试使用 R Studio 将 google sheet 与 power bi 连接，在 youtube 上有一个由 stephnie locke 制作的视频，但这只是一个简短的视频，并没有完全帮助.任何可以提供适当和完全帮助的人.

解决方案

如果你不限于 R Studio，还有另一种方法可以从 Power BI 访问 Google Sheet 数据:

样本数据:

1. 获取 Google 表格的可共享链接(至少获得任何知道该链接的人都可以查看的权限):

1. 修改分享链接，添加如下部分:

   发件人:

   4. 如果您深入到表格单元格，您应该能够看到数据并从那里开始工作.

   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:

   1. Get shareable link of the Google Sheet (Permission at least Anyone with the link can view):

   2. 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

   3. 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

   4. If you drill into the Table cell you should be able to see the data and work from there.

   这篇关于如何将谷歌表格与power bi连接?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！