One Dataset multiple reports - again

[rylach]

Hi.

I have one dataset, which should be a source for two kind of reports. The underlaying tables for both reports are partially common. The targe groups (report consumers) are separate. So, it seems that most resonable solution could be two separate reports based on one dataset - this would allow:

1. Maintain only one data model
2. Have two reports  / group of pages for the groups (possibli stored in one common workspace, but with data hidden for the other group by Row Level Security).

I found the solution saying "click on the dataset in Power BI and create the second report based on it, then save it to the .pbix file". Great!

But, when I save the .pbix file (under the new name) and then publish it again into the same workspace as the original one, then a new dataset is being created. I'd rather expect, that it will publish the new report, and the original dataset, i.e. without creating the new one.

Is there any solution for that ?

Best regards,

R.

[Seth_C_Bauer · Accepted solution]

@rylach Sounds like a slight mix up in functionalities. You can download a PBIX from a dataset (as you describe) but that isn't what you want.

What you want, is to open a clean Desktop file, go to Data Sources, and select the new option of "Power BI Service" This shows you the workspaces and datasets that you have edit rights for and you can select one.

Build your new report off the dataset, and you can only publish back to the same workspace. This method will not create a new dataset, just the new report.

[rylach]

Thanks for the reply.

Is this still true, that having edit rights for the workspaces means ability to read all the data (ommiting the Row Level Security) ?

[Seth_C_Bauer]

@rylach yes, I haven't heard anything about the rule changing.

[rylach]

So, it seems that Power BI authors assume, that only people having full rights to read the data should be able to create their own reports, right ? If one does not have 'edit' right in a workspace - he can't see the dataset. If does have - will see all the data. 

Pretty bad. I'll submit a feature request for that.

R.