Good afternoon, all, I hope this finds you well.
I am trying to create a Power BI report in service, however, it requires the use of two separate datasets with their own unique key measures and fact tables. Is there a way to integrate two different datasets into one report?
Cheers,
Hello @RoxanneRosenberg , thank you for adding your question to the Enterprise DNA Forum.
While not clear in your question and without access to your work-in-progress Power BI file to inspect the data model and source connection types, one solution would be to use a Composite model. For this to apply, at least one of the source groups is Direct Query.
If you need additional assistance, please share your work-in-progress Power BI and provide more details about your source groups and environment.
Good afternoon, @ystroman and thank you for responding to my comment - I will explain below…
We have 1 large data set of published purchase data and have 1 large data set of published sales data. I need to use information from both data sets into 1 report.
How can I utilize both published data sets into 1 Power BI report aside from manually copy and pasting the information from 1 data set to the bottom of the other?
Hello @RoxanneRosenberg,
If you need additional assistance, please share your work-in-progress Power BI file and data set(s) in Excel format and provide a mockup of how the final report should look like.
For concerns around sensitive and confidential data contained in the model, please refer to the following EnterpriseDNA Forum thread and video by Brian Julius who is one of our EnterpriseDNA Experts.
The link is : https://forum.enterprisedna.co/t/tip-tools-and-techniques-for-providing-pbix-files-with-your-forum-questions/17763
Within that page is a link to the following video, and hosted on Youtube, and contains a number of simple techniques for masking names, dates and numbers in Power Query.
How To Mask Sensitive Data In Power BI
The following EnterpriseDNA Blog article may be helpful during the preparation of the Power BI file(s) requested.
How To Append Power Queries Table In Power BI | Enterprise DNA
Thank you, @ystroman, this was helpful!
Hello @RoxanneRosenberg, checking in to see how you are coming along with this issue.
–
Did this answer your question? Please mark it as the solution.
Did it contribute positively towards finding the final solution? Please give it a like.