dynamic parameter value in sql query source power bi

[ahmadov_10]

Hello Experts,

i need to deliver a report based on a dynamic field "Region_id" to the end users. the report contains one table built with a query SQL : query from SQL table concatenate in where with parameter value. (the query above)

it works fine now and i can see the difference when i change the parameter value , it's nice to manage high volume of data (30 millions rows in total and 2 millions per region)

So the problem : how to do it dynamic in the server : when a user (from region_id = 4) see the report , the report loads data for region_id = 4 and he can see only the data of his region.

I'm open for any solution (my report in import mode , but if necessary i change for direct query mode)

Happy to share with you Super stars : @Greg_Deckler @amitchandak @PhilipTreacy  @ImkeF @AlexisOlson  @ppm1 @Anonymous  

[AlexisOlson]

If you need access to more than one region without changing the parameter, you can either import all of the regions you'll need or else set it up as a DirectQuery where it queries the source for the region(s) as they are needed.

[ahmadov_10]

Hi Alexis : no, due to the large volume, the report cannot be published on the service if the total data is loaded. So, I would like to set up a dynamic loading solution, where each user in the workspace according to his role, consume the data of his region.
I think this is the best solution to solve the volumetrics problem and have a single data source.