workspaces, Parameters and datasets in powerbi service

[angelikamariae]

Hi Community

I have the next situation:

I want to create a report with a dataset that comes from an store procedure excecuted with parameters.  In order to increase the performace of the data loading I wanted to split the info comming from SQL.  The parameters will be the year and the company name and I am planning to share this into a workspace. 

Each user seeing the report might need to change the year or the company according to his needs and then refresh the dataset.  What I am wondering is if everytime some one changes the parameters and refreshes the dataset that will change the dataset of the other users who are currently seeing this report?  Please note that because of the parameters the dataset will come with one year at the time.

for ex:  User1 wants to see the report for 2020 but User2 connected at the same time wants to work in the data for 2019.  is it possible? is it the dataset an instance for each user? or it is unique for the workspace?

In case my aproach is not correct is there a better way to approach this situation?

Thanks in advance

Angelica.

[v-jayw-msft]

Hi @angelikamariae ,

If you change the parameter and refresh the dataset, all users will be affected.

You can try use slicers and filters as @Greg_Deckler  mentioned above.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers.

https://docs.microsoft.com/en-us/power-bi/power-bi-report-add-filter.

And please check the documents about Row-level security in Power BI.

https://docs.microsoft.com/en-us/power-bi/desktop-rls.

https://docs.microsoft.com/en-us/power-bi/service-admin-rls.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[angelikamariae]

Hi Grey and Jay.

Thanks for having the time to reply to my question and thanks for the links.

I have seen the slicers which I think is cool, but it will still put me in the situation of downloading the whole data with all the years info wich is slow because is will often need to be refreshed.  This is what I was trying to avoid with an store procedure with parameters. So I got into this question.

I though also about the posibility of choosing the parameters from the report, but looks like it is not possible to have it directly there but going to the configuration and that is not users friendly, even if I get there I still will have to deal with the fact that the dataset will change for all the users 😞

It looks like the only way for me will be deal with direct query or see how bad will be refreshing all the data everytime..

Thanks

Angelica.

[Greg_Deckler]

It will change the dataset for all users.

Better to bring it all in and slice and dice it in Power BI if feasible.