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

问题描述

PowerBI 仅为分页报表提供了 CSV 格式导出 API，而不是通过导出 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/en-us/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.

推荐答案

不，没有将 Power BI 报告导出为 CSV 的 API.当设计正确时，这应该从用于构建 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.

首先，您可以使用一些 客户端库 连接到数据集的XMLA 端点，但这需要高级版(公告 此处 和用于读/写 此处).

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屋！