Forum Discussion
Power 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.
Hi 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...
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