Forum Discussion
Query parameters displayed value doesn't refresh in Power BI Service
I've experienced this bug but perhaps can sprinkle a bit more color here that (hopefully) expedites this bug's resolution. When I added my parameter, in order to access this parameter's native value in the report (in my case, to generate a dynamic URL), I had to click "Enable Data Load" on said parameter. When I do this, a special table is created in my report for that parameter with a single value. When I then publish the report with a hard-coded value assigned in PBI Desktop for testing purposes, I log into PBI Web and change that parameter in the Dataset's Settings dialog. It seems that herein lies the issue. When I do a data refresh out on the cloud, my Advanced Query pulls this parameter value correclty (after a couple of tries, this too is spotty) but eventually is used properly. But it seems the special dataset loaded into the report (Import Data, not DirectQuery) for this parameter's value is not refreshed from the Parameter value we define in PBI web. As a workaround, we've updated the hard-coded value for each branched report in PBI Desktop and this resolves. But that won't resolve for the other community members in this thread as they're trying to override dynamically - in the end, the fix should be this: Parameters set in PBI Web should carry into the special table created for parameters set to "Enable Data Load" when a dataset is refreshed out on the web. In other words, the values defined out on app.powerbi.com should supercede any hard-coded values for these parameters set during local PBI Desktop testing, and - perhaps most importantly - cloud-triggered data refreshes should properly carry over PBI web-defined values into these special, imported tables.