Forum Discussion
Creating a dashboard with multiple datasets foreach company
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!
Change Database & Server name dynamically using Query Parameters in Power Bi
https://www.youtube.com/watch?v=E1z5TvfVNlM
check this video, if it could help you
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!