How to manage data from different departments databases into one report

[MrCrow]

Hi all!

Currently i have made a few different databases.  One for shipping, sales, production and eventually will have a few more for the rest of our comapny.   My question is, if i wanted to make a report that included data from every department, what is the best way to pull the data from the seperate databases.   

I thought it was a good idea to keep each department into seperate databases to have everything organized but I cant figure out a good way to get data from multiple databases at once.   Is the right move to make one mass database instead of seperate ones?   If so is there an easy way to combine them at the moment without wrecking my current reports?  

Thanks!   

[amitchandak]

@MrCrow , You need to have Global/Common dimensions for department/date etc, and use them to analyze data together. They can be created at DW/Dataflow /Power Query or DAX as per need

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...

Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw

[MrCrow]

So, is there a way to get the two seperate power bi databases to interact together?   When i try to connect to two databases i got the "Value cannot be null" error.