Martin on 02 Oct 2018 20:22:09
Currently you can only change parameter values online within imported data sources, this would be useful to have on direct query and live connection data sources also as the ability to move through environments without redeploying is very useful for organisations.
- Comments (12)
RE: Change parameter values within direct query sources
I have multiple locations that each have a Local DB with the same schema setup. Identical setups. I need to be able to change connection strings for each locations DB when in the Locations Workspace. Redeploying multiple times for each report or data change after changing ALL the direct query sources is just not feasible.
RE: Change parameter values within direct query sources
To expand upon this idea, we are looking to be able to modify the Direct Query parameters from PBI Service.
Use Case:
1. We define parameters within the PBIX file in PBI Desktop on Direct Queries
2. A parameter that we might define will limit the data being sourced into PBI Desktop so that the PBIX can be more easily worked with in desktop (smaller data set)
3. We then, publish the PBIX file to PBI Service in Premium Capacity
4. We change the values in the parameters of the data set setting to expand the amount of data we are souring
We currently can do this when using the Import Query, but it is not available when using Direct Query