Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
@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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
87 | |
61 |