Forum Discussion
Using Parameters on PBI desktop with a Live Connection to SSAS Tabular
Hello everyone,
I can't seem to find an answer to my query so cannot be sure if it has been asked before but I apologize if it has.
So I have started to use a live connection to an SSAS tabular server for my PBI reports. The idea being, its a centralized source, and would offer better performance.
One of the key features many of our end users use is the input parameter function (basically enabling the report to filter/update based on an arbitrary value input into the parameter box). Unfortunately with the live connection, the parameter button has been greyed out. Anyone know of a workaround or fix for this? How else can I achieve the same function as a parameter input box?
see below:
showing live connection
You can use dummy table in cube, means let's say you want to take input from number, based on your requirement you can create one dummy table having one column with number series like 1 to 100 or anything.
Create table in model and don't make any relationship with that table.
Now use that column in slicer and write measure.
Let's say in your fact you have one measure and you want to display measure only if it is greater than selectedValue.
So create measure at power BI level/Cube level, it works fine in both condition.
Measure=if(Sum(Fact[amount])> Selectedvalue(Dummy[Series]),1,0)
Add measure in visual level filter and set measure is 1.
For data inputs as well you can create one data dummy table in cube and used it as slicer.
Calculated table as
Date Table =CALENDAR (DATE(2000;1;1); DATE(2025;12;31))