Forum Discussion

rnola16's avatar
rnola16
Icon for Advocate II rankAdvocate II
1 year ago
Solved

Unable to change Parameters in Workspace semantics.

Hi all,   I have a semantic model that uses parameters on a report that is published to a workspace. As an admin I'm able to make changes on the parameter values and run them. I'd like to have user...
Need Help
  • rnola16's avatar
    rnola16
    1 year ago

    Was able to configure the reason in the M code. Able to work it out with Mass Filter.

rnola16's avatar
rnola16
Icon for Advocate II rankAdvocate II
1 year ago

Report Slicers and RLS are good for small data sets. These tables are huge with billions of records and if a user want to query for an ID, he should be able to query for that ID and the query run should be handled by the database and not by the report server ( in other ways QueryFolding).

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi rnola16 ,
A workaround is to embed a Power App inside the Power BI report. This Power App can collect user inputs such as dates, IDs and send them to a database. The updated values are then stored in a database table, which Power BI references as a data source. This method ensures that queries are executed at the database level, leveraging query folding to improve performance.

Hope this helps.If so, kindly accept it as solution to help others quickly.