Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have between 5-100 companies (range given to see if impacts suggestions) and would like to implement Power Bi across them to provide:
Does anyone have any recommendations on how to achieve this?
Thanks
Solved! Go to Solution.
@BigBadBob it is very vague information but best practice would be to have one centralize dataset from all the companies, and implement Row Level Security, so the users from individual company see their own data and with elevated permission, management can see all companies data.
There are many ways to handle this but I think this is a good starting point. Feel free to reach out if you have further questions.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@BigBadBobI worked in a very similar situation, where a company had many acquisitions and all of them came with their own ERPs and systems.
Basically, this is what we did.
1. Set up a common business intelligence datawarehouse - can be platform of choice. We just used SQL Server.
2. Build common data structures for sales, finance, operations etc - most of these are very standardized and reference implementations are available. Additional fields such as Company/Brand etc helps identify specific group company
3. Bult integration jobs from each of the source systems into the warehouse.
4. Built a set of common reports on top of the consolidated tables.
5. Adjusted for any idiosyncracies or special business requirements of any group company. One can always build a specific report as needed.
Hope this is helpful 🙂
@BigBadBobI worked in a very similar situation, where a company had many acquisitions and all of them came with their own ERPs and systems.
Basically, this is what we did.
1. Set up a common business intelligence datawarehouse - can be platform of choice. We just used SQL Server.
2. Build common data structures for sales, finance, operations etc - most of these are very standardized and reference implementations are available. Additional fields such as Company/Brand etc helps identify specific group company
3. Bult integration jobs from each of the source systems into the warehouse.
4. Built a set of common reports on top of the consolidated tables.
5. Adjusted for any idiosyncracies or special business requirements of any group company. One can always build a specific report as needed.
Hope this is helpful 🙂
Thank you very much for the below response. It gives a nice structure to how this was achieved.
It would be interesting to chat to you more about this. Would it be possible to private chat? Thanks again Andrew
@BigBadBob Sure, my email is in my signature, please feel free to reach out. Cheers!!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@BigBadBob it is very vague information but best practice would be to have one centralize dataset from all the companies, and implement Row Level Security, so the users from individual company see their own data and with elevated permission, management can see all companies data.
There are many ways to handle this but I think this is a good starting point. Feel free to reach out if you have further questions.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.