Forum Discussion

MrCrow's avatar
MrCrow
Icon for Helper I rankHelper I
3 years ago

How to manage data from different departments databases into one report

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 mak...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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-solution-8e3eccb41bda

 

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

MrCrow's avatar
MrCrow
Icon for Helper I rankHelper I
3 years ago

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.