Forum Discussion
Field Parameter appear as count
- 11 months ago
It's solved FP Don't work with mixed storage
Live only working fine
Thank you all
This could be due to the difference in datatype of the field parameter column.
It's working in the semantic Model and tested , but not working in the live report ( data source is the semantic Model )
- FarhanJeelani11 months agoSuper User
Hi ahmedshalabyy12 ,
this is most likely due to field parameters not being supported with a live connection to a semantic model (SSAS/Analysis Services). When you use a live connection, Power BI can’t evaluate the dynamic field parameter the same way as in an imported dataset, so the visual ends up showing a default aggregation like Count.
What you can try or consider:
If possible, switch to an imported Power BI dataset (or publish a Power BI dataset) instead of using a live SSAS connection. Field parameters work in that scenario.
If you must stay with a live semantic model, field parameters are not reliable for dynamic measure switching. In that case you have two workarounds:
Implement the dynamic measure logic on the server side (in the semantic model) using pre-defined measures and a slicer (DISCONNECTED parameter table) that maps to those measures. Note: this requires you to modify the semantic model itself.
Use separate measures in the report (Sum, Avg, Count) and provide a manual way to switch visuals via bookmarks or a slicer, but this won’t be a true field parameter switch in real-time.Check the datatype of the field parameter column in the semantic model. A mismatch (e.g., numeric vs text) can cause odd behavior. If you can, ensure the parameter column is a text/string type and that the parameter table is properly designed for a field parameter.
Please mark this post as solution if it helps you. Appreciate Kudos.
- ahmedshalabyy1211 months agoHelper V
I just test another field parameter with another live report and it's working fine