英文:
PowerBi automation and dynamic reports
问题
我正在使用PowerBI创建包含客户数据的报告。底层数据是相同的，来自SQL数据库。但是这些数据库因客户而异。
是否有办法可以在不为每个客户进行调整的情况下，使用相同的报告和翻译等，只是从数据库中提取数据呢？
谢谢。
简单地将其他数据库添加到连接中不会起作用，因为表格不会正常工作。
英文:
I am using powerBI to create raports with customer data. The underlying data is the same, it comes from an SQL database. But this databases differs from customer to customer.
Is there a way that i could use the same raport and translations etc without adjusting it for each customer? just pulling the data from database.
Thx
simply adding other database to the connection wont work, as the tables wont work properly.
答案1
得分: 0
推荐的方法是为每个客户分配一个工作区，并通过参数配置报告的副本以连接到客户的数据库。
要创建可扩展的多租户解决方案，您必须能够自动化创建新的客户租户。典型的为新客户租户分配通常涉及编写代码，使用Power BI REST API创建新的Power BI工作区，通过导入Power BI Desktop (.pbix)文件创建数据集，更新数据源参数，设置数据源凭据以及设置定期数据集刷新。以下图表显示了如何向工作区添加Power BI项，如报告和数据集，以设置客户租户。
英文:
The recommended approach for this is to provision a workspace for each customer, with a copy of the report configured through a parameter to connect to the customer's database.
> To create a scalable multitenancy solution, you must be able to automate the creation of new customer tenants. Provisioning a new customer tenant typically involves writing code that uses the Power BI REST API to create a new Power BI workspace, create datasets by importing Power BI Desktop (.pbix) files, update data source parameters, set data source credentials, and set up scheduled dataset refresh. The following diagram shows how you can add Power BI items, such as reports and datasets, to workspaces to set up customer tenants.
Develop scalable multitenancy applications with Power BI embedding
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论