从已发布的 Power BI 视觉对象中抓取数据 [英] Data scraping from published Power BI visual

问题描述

如何以任何编程方式将数据从已发布的特定 Power BI 视觉对象导入另一个 PBI 报告或 SQL Server 表，或者只是将其废弃到本地驱动器?我想达到与点击已发布PBI视觉效果右上角的三个点...相同的效果 > export data> 另存为到本地驱动器.

How to import data in any programming way from published specific Power BI visual to another PBI report or SQL Server table or just scrap it to local drive? I would like to achieve the same effect as by clicking on three dots ... in the right upper corner of published PBI visual > export data > Save as to local drive.

这为我提供了我需要的整个数据表，而无需考虑其他人如何生成视觉效果的复杂性(即在未知键上加入许多表).无论优缺点如何，我都想从 PBI 视觉的外部报告中获取数据，而不是从 Power BI 数据集 或任何其他初级外部报告来源获取数据.

This gets me the whole table of data I need without looking at the complexity how the visual was produced by someone else (i.e. joining many tables on unknown keys). Whatever the pros and cons, I want to get data from the external report of PBI visual, not from Power BI datasets nor from any other primery source of external report.

理想情况下，我想插入外部报表的视觉效果作为 Power BI 报表的来源.如果这不可能，有什么办法可以使用 R 打开 PBI 外部报表，并将数据从特定视觉导出到 R data.frame?如果没有，也许可以用 Python 或任何其他专为数据抓取设计的程序来完成?

Ideally, I would like to plug to the visual of external report as a source in my Power BI report. If that is not possible, would there be any way using R to open the PBI external report, and export data from specific visual to R data.frame? If not, maybe it could be done in Python or any other program designed for data scraping?

推荐答案

我会尝试使用 JavaScript 库中的 exportData 方法来嵌入 Power BI:

I would try the exportData method from the JavaScript library for embedding Power BI:

https://github.com/microsoft/PowerBI-JavaScript/wiki/导出数据

您的屏幕截图暗示您正在通过 Power BI Web 服务 app.powerbi.com 访问报告.使用该门户打开报告后，菜单选项共享/嵌入报告/网站或门户将为您提供开始使用所需的安全令牌.

Your screenshot implies that you are accessing the report through the Power BI web service app.powerbi.com. Once you have opened the report using that portal, the menu option Share / Embed report / Website or portal will give you the secure token you need to get started.

这篇关于从已发布的 Power BI 视觉对象中抓取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！