Forum Discussion
Question Power BI Datasets and Composite Models
Dear all,
I am new to PowerBI and currently we try to find out what is the best way to implement PowerBI in our organization.
We would like to create several reports from different sources.
My question is:
Data sources:
- sales
- production
- logistics
- HR
The idea is to create for each of those sources a datamodel in one PowerBI dataset and upload it into PowerBI Service.
For some reports we need to combine two of those datasets to create measures which combine for example sales and production data. If I correctly understand this composite models bases on two Power BI datasets are now allowed.
So what is the solution for this? Try to load all data from all different sources into one big PowerBI dataset to have one source for all our reports in the organization?
If the creation of one dataset is the right solution i read a Power BI dataset can be max 1 GB, 2 billion rows and 16.000 columns. Has a dataset with this size still good performance?
Hope you understand the question. We are in a early state of implementation and looking for the right way to go.
Thanks for your help!
Hi DMTS ,
Use the desktop to connect to the dataset in the service. This connection is live-connection and only one dataset is allowed.
The solution is to connect to different data sources in the desktop to create reports and the publish to service.
In service, if you want to realize the interaction in different reports, you can learn about this document.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through
Power Bi working with large datasets which will cause performance problems, but there are some optimization schemes for your reference:
https://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi DMTS ,
Use the desktop to connect to the dataset in the service. This connection is live-connection and only one dataset is allowed.
The solution is to connect to different data sources in the desktop to create reports and the publish to service.
In service, if you want to realize the interaction in different reports, you can learn about this document.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through
Power Bi working with large datasets which will cause performance problems, but there are some optimization schemes for your reference:
https://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Dear V-lianl-msft,
Thanks for your answer.
The cross-report-drill-through functions sound interessting. Does this one also allow to create cross report measures?
The idea was to build up for each data topic production, sales, logictis a master dataset and upload it into the PBI service to create reports based on this master datasets. The reason is to maintaine only one dataset for each topic.
For some measures we need to make cross dataset calculations, which is not possible because there is only one live-connection allowed. How to deal with this?
I was a video from Microsoft in which they presented semantic models in which they connected to two PBI datasets within the PBI service (approx. minute 14 in this video link below).
Do you know which licenze do I need or is this an upcoming update?
MyBusiness Applications Summit - Modern Enterprise BI (microsoft.com)
Thanks for your help
Instead of connecting to the PowerBI dataset with the live connector, connect to it via the SSAS connector.
" If I correctly understand this composite models bases on two Power BI datasets are now allowed."
Thannkfully that is not correct. You can combine any number of data sources in the composite model. You are right to be concerned about performance, however the only real way to judge it is to try it out. Which SKU (capacity) are you planning to purchase?
