英文:
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.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论