Forum Discussion
Advocate VPower BI Report Builder - Tabular model data source (Questions)
Hi 101Mathew ,
Thank you for staying engaged and sharing your concerns.I understand that this issue might require a more detailed, hands on approach. While we've covered several possible solutions, I recommend reaching out to a certified Power BI partner for support tailored to your specific needs.
Power BI Partners – https://www.microsoft.com/en-us/power-platform/products/power-bi/partners#
Regards,
Yugandhar.
Advocate VThank you -
* Parameters used by end report users - When using the Query Designer, it auto creates a parameter and dataset for that parameter. - Selecting All as the default within the query designer does not work
I've had to go to the hidden dataset that is auto created and update it to fig 1: I used copilot to help as I did not understand the original query that was auto generated and how it hang together with the parameter:
This was the code auto generated for it originally:
EVALUATE SELECTCOLUMNS (ADDCOLUMNS (SUMMARIZECOLUMNS (ROLLUPADDISSUBTOTAL ('Income Account Exec'[AccountExec], "h0")), "ParameterLevel", if ([h0], 0, 1)), "ParameterCaption", SWITCH([ParameterLevel], 1, 'Income Account Exec'[AccountExec], "Blank()"), "ParameterValue", 'Income Account Exec'[AccountExec], "ParameterLevel", [ParameterLevel], "'Income Account Exec'[AccountExec]", 'Income Account Exec'[AccountExec]) order by 'Income Account Exec'[AccountExec], [ParameterLevel]
I've found another issue, after auto generating the parameters (when click for end user use) and dataset (when using the query designer), if you change the filtered value to later on, this is (again in the query designer), this value does not update
I do think it's vital - if there are auto created items by the App that it works out of the box - Also there should be details on how to adjust/format code; the auto created code is hard to read, (the main query is vastly worse then the auto code for the parameter)
Fig 1
Community SupportHi 101Mathew ,
I understand your frustration. Auto generated queries in Power BI Report Builder can be tricky to work with, especially when they don’t behave as expected.
Power BI Report Builder automatically creates a parameter and a dataset for it. However, setting Select All as the default doesn’t work out of the box. Since the default selection doesn’t apply correctly, manually adjusting the hidden dataset is the best approach. This ensures that the parameter correctly reflects all available values.
If the filtered value doesn’t update dynamically after modifying it in the Query Designer, it could be due to caching or dataset dependencies. Sometimes, manually editing the query outside the designer is necessary to ensure correct behavior.
Here are some useful references
A community discussion that addresses similar parameter related issues.
Solved: Error message with paramaters Report Builder - Microsoft Fabric Community
Microsoft documentation explaining how parameters function in paginated reports.
Report parameters in Power BI Report Builder - Power BI | Microsoft Learn
I hope this helps...
- 101Mathew
As always, thank you for your information. The lesson here is that this solution is not ready for self-service without development by Microsoft, proper documentation, and guides—or it requires significant development time by your staff, still leaving some blind spots and uncertainty.
I will try to steer my team away from this solution unless absolutely necessary