从发布的Power BI visual中抓取数据 [英] Data scraping from published Power BI visual

问题描述

如何以任何编程方式将数据从已发布的特定Power BI视觉文件导入到另一个PBI报表或SQL Server表中，或者仅将其剪贴到本地驱动器中?我想要达到与单击已发布的PBI视觉图形的右上角 ... 中的三个点 ... 相同的效果> 导出数据> 另存为到本地驱动器.

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 visual的外部报告中获取数据，而不是从 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 visual中抓取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！