I share an Excel spreadsheet with some colleagues via Onedrive but we don't have any Microsoft BI tools. I'd like to use the Google Charts API to query some data from this sheet and present it in the form of a bar chart. Ideally the chart would change as we update the table.
我通过Onedrive与一些同事共享Excel电子表格,但我们没有任何Microsoft BI工具。我想使用Google Charts API查询此表中的某些数据,并以条形图的形式显示。理想情况下,图表会随着我们更新表格而改变。
Unfortunately, I don't see anything in the Google documentation about querying non-Google data. The Onedrive API documentation is also quite confusing. Does anyone have experience with this? Is there an easier way to do this other than SharePoint and other paid solutions?
不幸的是,我在Google文档中没有看到有关查询非Google数据的任何内容。 Onedrive API文档也很混乱。有任何人对此有经验吗?除了SharePoint和其他付费解决方案之外,还有更简单的方法吗?
1 个解决方案
#1
0
Yes, there is. It is Microsoft's Power BI. You can access the free Power BI service, load data from OneDrive, create charts other visualisations in reports, pin visualisations to dashboards.
就在这里。这是微软的Power BI。您可以访问免费的Power BI服务,从OneDrive加载数据,在报告中创建其他可视化图表,将可视化引入仪表板。
You can share dashboards and reports with colleagues in the same domain. Power BI has apps for mobile platforms.
您可以与同一域中的同事共享仪表板和报告。 Power BI有适用于移动平台的应用程序。
You can download the free Power BI for Desktop to design reports and publish to your organisation.
您可以下载免费的Power BI for Desktop来设计报告并发布到您的组织。
Some advanced features of Power BI are only available with a paid subscription, but the free version has more stuff than many people will ever use. Go to http://powerbi.com and have a look around.
Power BI的一些高级功能仅适用于付费订阅,但免费版本的内容比许多人使用的要多。访问http://powerbi.com并浏览一下。
#1
0
Yes, there is. It is Microsoft's Power BI. You can access the free Power BI service, load data from OneDrive, create charts other visualisations in reports, pin visualisations to dashboards.
就在这里。这是微软的Power BI。您可以访问免费的Power BI服务,从OneDrive加载数据,在报告中创建其他可视化图表,将可视化引入仪表板。
You can share dashboards and reports with colleagues in the same domain. Power BI has apps for mobile platforms.
您可以与同一域中的同事共享仪表板和报告。 Power BI有适用于移动平台的应用程序。
You can download the free Power BI for Desktop to design reports and publish to your organisation.
您可以下载免费的Power BI for Desktop来设计报告并发布到您的组织。
Some advanced features of Power BI are only available with a paid subscription, but the free version has more stuff than many people will ever use. Go to http://powerbi.com and have a look around.
Power BI的一些高级功能仅适用于付费订阅,但免费版本的内容比许多人使用的要多。访问http://powerbi.com并浏览一下。