Forum Discussion

JangoChained's avatar
JangoChained
Frequent Visitor
2 years ago
Solved

Creating a dashboard with multiple datasets foreach company

Hello fellow power bi users, so I have a power bi dashboard that I want to use on 2 different companies, where each company has a unique dataset. I don't know if I should make an account for every co...
General Comment
  • JangoChained's avatar
    JangoChained
    2 years ago

    Hi, this didn't solve my problem but with the help of a coleague and the info from microsoft https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets I know how to do it now. You can create dataflows for each company connecting the database with the pb, then you connect each dataflow with the pb empty, without data, so the pb fills with the data of the dataflow that you want. You put each dataflow/pb in a workplace and then you give each company acces to just the pb + dataset with only the permissions that you wanna give them. 

    Thx anyways for the help!

JangoChained's avatar
JangoChained
Frequent Visitor
2 years ago

Hi, so I will be making a lot of changes to the report, one week maybe they can see visualizations based on sales, the next one they will change to accountant visualizations and so on. 

I don't wanna change the report everytime for each company, that's why i need to come with a solution, but i don't know how to do it while each company has a unique dataset.