通过Rest API以csv格式导出PowerBI报告 [英] PowerBI Report Export in csv format via Rest API

问题描述

PowerBI仅为分页报表提供了CSV格式导出API，而对于仅通过Export API仅支持pbix，ppt，png格式的普通报表不提供此格式.

PowerBI provided CSV format export API for Paginated Reports alone, not for normal reports which support only pbix, ppt, png formats via Export API.

参考:https://docs.microsoft.com/zh-cn/rest/api/power-bi/reports/exporttofile

Reference: https://docs.microsoft.com/en-us/rest/api/power-bi/reports/exporttofile

是否有API以CSV格式导出普通PowerBI报告?

Is there any API to export normal PowerBI reports in CSV format?

如果没有，是否有任何API可以获取特定报告中的确切数据?

If not, is there any API to get the exact data present in a particular report?

您已经很长时间了，请您帮我解决这个问题/清楚吗?

Can you please help me with a solution/clarity on this since am looking for it for a long time.

推荐答案

否，没有API可以将Power BI报告导出到CSV.当设计正确时，这应该从数据源导出，该数据源用于构建Power BI报表本身.仍然有一些选项可以做到这一点，但是您可能不喜欢它们.

No, there is no API to export Power BI report to CSV. When designed properly, this should be exported from the data source, which is used to build the Power BI report itself. There are still some options to do that, but you may not like them though.

首先，您可以使用一些

First, you can use some client library to connect to the dataset's XMLA endpoint, but this requires Premium (announcement here and for read/write here).

其他选项，例如在Excel中分析和从可视化导出数据，具有手动步骤，并且

The other options, like Analyze in Excel and exporting data from visualization, has manual steps and bad limitations, which you may try to simulate, but I don't think this is a good solution.

结论是，最好的解决方案是建立适当的层，并完全避免从报告层导出数据.

As I conclusion, the best solution would be to make proper layers and avoid exporting data from the report layer at all.

这篇关于通过Rest API以csv格式导出PowerBI报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！