Requesting a report with dynamic parameter

[Gunabu]

Hi,

I'm currently investigating whether or not we can use PowerBI for a project. We want to be able to fetch a report (via API) while providing a parameter to filter the dataset of the report. 

I've managed to set a parameter in the report itself, but the problem is that the only way I find of setting this "dynamically" is to access the dataset via the API and update the parameter. However, this is an issue because it seems like this just sets the parameter globally for the report (in addition to the API doc mentioning it might take up to 30 minutes to update properly...). And we might have several users accessing the same report and each wanting to filter the dataset in it's own way. 

I've also found some post-load filter ways of handling this, but the problem is our dataset is fairly huge. So we want to filter it before we actually retrieve the data. Is there a way to do this?

[lbendlin]

You may not have that option but what you describe either requires a Direct Query connection or the use of RLS (Row Level Security).  Per user parameters are not yet possible.