如何在Power BI报告生成器中从外部文件中读取数据源配置。

huangapple go评论105阅读模式
英文:

how to read the data source configuration from an external file in Power BI report builder

问题

我们已经在Power BI报告生成器中开发了一个分页报告。在分页报告中,我们已经创建了一个数据源,并将其指向了Power BI中的一个数据集。

现在我们有一个要求,根据发布分页报告的工作区,动态地将报告指向不同的数据集。所有的数据集具有相同的结构,但数据根据数据集所在的工作区而异。

一种选择可能是检查是否可以从文件中读取数据集路径。另一种选择是使用相对路径,其中文件从发布分页报告的工作区中读取相同名称的数据集。

然而,我还没有看到任何这样的可能性。如果有人知道如何实现这一点,我将不胜感激。

致敬
Syed

英文:

We have developed a paginated report in Power BI report builder. In the paginated report, we have created a data source and pointed it to a dataset in Power BI.

Now we have a requirement to point the report dynamically to different datasets depending upon the workspace where the paginated report is published. All the datasets have the same structure but different data depending on the workspace where the datasets reside.

One option could be the possibility to check if the dataset path can be read from a file. Another option would be to use a relative path where the file reads the same name dataset from the workspace where the painted report is published.

However, I have not seen any such possibility. I would appreciate if someone knows how this can be achieved.

Regards
Syed

答案1

得分: 1

你可以在部署之前修改 .rdl 文件来实现这一点。RDL 是 .XML 格式并且有完整的文档,所以这应该很容易。

或者在部署后调用 Update Datasources REST API 来实现。

英文:

You can do this by modifying the .rdl file before deployment. RDL is .XML and fully documented, so this should be easy.

Or by calling the Update Datasources REST API after deployment.

huangapple
  • 本文由 发表于 2023年5月22日 21:21:27
  • 转载请务必保留本文链接:https://go.coder-hub.com/76306647.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定