如何在不破坏报告的情况下更新客户的 Power BI 文件? [英] How to update clients' Power BI files without ruining their reports?

问题描述

我们有很多客户端，每个客户端的服务器上都有一个数据库(都具有相同的结构).我正在尝试准备一个基础 Power BI 文件，该文件能够从服务器获取数据并且具有业务逻辑(计算列、度量值等).但每个客户都需要自己的报告.

We have lots of clients each having a database(all have same structure) on their servers. I am trying to prepare a base Power BI file which has the ability to get data from the server and has business logic (calculated columns, measures etc.). But every client needs their own reports.

我正在尝试准备 Data 和 Relationships 选项卡，而客户正在准备 Report 选项卡.

I am trying to prepare Data and Relationships tabs and clients are preparing Report tab.

但如果我想更新业务逻辑怎么办?如何更新客户的文件不破坏他们已经准备好的报告?是否有仅将业务逻辑导入到文件的选项?还是我做错了这种计划?

But what if I want to update the business logic? How can I update clients' files without ruining their already prepared reports? Is there an option to import only business logic to a file? Or am I doing wrong with this kind of planning?

注意:如果我重命名某些列/度量或进行某些关系更改，这会导致某些报告出现错误.我知道这一点，并想忽略这种情况.即使发生这种情况，有些报告可能需要引起注意，仍然比在所有更新中创建所有报告要好得多.

Note: If I rename some columns/measures or make some relationship changes, this would lead errors in some reports. I am aware of this and want to ignore this situation. Even if this happens, some reports may need some attention, still much better than creating all reports in all updates.

推荐答案

使用我在这篇文章的评论中描述的黑客:http://byobi.com/blog/2016/05/strategic-prototyping-power-bi-desktop-vs-power-pivot/您实际上可以在工作簿之间移植"模型.

Using the hack I've described in the comments to this post: http://byobi.com/blog/2016/05/strategic-prototyping-power-bi-desktop-vs-power-pivot/ you can actually "transplant" the model between workbooks.

注意:您必须替换这 3 个元素:DataMashup、DataModel 和 Metadata

Note: You have to replace these 3 elements: DataMashup, DataModel and Metadata

有人已经在想法部分发现了针对此问题的功能请求吗?:https://ideas.powerbi.com/forums/265200-power-bi

anyone spotted a feature-request for this issue in the ideas-section already?: https://ideas.powerbi.com/forums/265200-power-bi

这篇关于如何在不破坏报告的情况下更新客户的 Power BI 文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！