Forum Discussion
dynamic parameter value in sql query source power bi
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...
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.
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.