Forum Discussion
Combine 2 Data Sources into Reports
Hi all,
Would it be possible that combine 2 data sources from Microsoft Dynamics NAV (on-prem) and Microsoft Dynamics 365 Business Central? Pls enlighten me how to do the data merging, so we can create a report with 2 data sources.
Thank you!
Hi Anonymous ,
First, you can refer to the following documents to connect to the data sources Microsoft Dynamics NAV (on-prem) and Microsoft Dynamics 365 Business Central in Power BI Desktop respectively.
How to Configure Power BI for Microsoft Dynamics NAV
Add Business Central as a data source in Power BI Desktop
How to Connect Multiple Data Sources in Power BI
Then refer to the following document to shape the data from these two data sources separately, and combine them according to the conditions. You can refer to the following document for the detailed steps.Shape and combine data in Power BI Desktop
Best Regards
3 Replies
Anonymous , if you want to merge data, better merge it in data warehouse with the instance id of each instance. Create new join keys if need and then use in power bi
Or you need merge in power query, add instance id and create combine key (with instance id) and use them in join
Hey Anonymous ,
sure, you can import as many tables as you want. After you imported them, you can then do a merge (=SQL Join) or an append (= SQL UNION) of the 2 tables:
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicHi Anonymous ,
First, you can refer to the following documents to connect to the data sources Microsoft Dynamics NAV (on-prem) and Microsoft Dynamics 365 Business Central in Power BI Desktop respectively.
How to Configure Power BI for Microsoft Dynamics NAV
Add Business Central as a data source in Power BI Desktop
How to Connect Multiple Data Sources in Power BI
Then refer to the following document to shape the data from these two data sources separately, and combine them according to the conditions. You can refer to the following document for the detailed steps.Shape and combine data in Power BI Desktop
Best Regards
