Forum Discussion
Parameters Missing
Yes, but the SSRS report is based upon a data set that has all of the data loaded into it either via the actual transactions themselves or the ETL function that loads up all of the data. This is exactly equivalent to the data model in Power BI.
When the user in SSRS selects parameters, the SSRS report is essentially building a query to query the database and return the relevant rows. This is analogous in Power BI to the use of slicers.
In review. Your database behind your SSRS report has all of those "useless rows" in it because it needs to have them in order for the SSRS report to query it to return the relevant rows for the visualizations. Power BI data model also needs all of those useless rows in its dataset in order to return relevant rows for its visualizations.
What it sounds like what you really want is Direct Query which avoids the whole import process that you do not seem to like. But, I believe in one of the multiple, multiple, multiple threads that you have posted on this topic that you don't like Direct Query either.
I'm trying to use parameters with Databricks data in a published report. Everything works great in Desktop, but the moment the report is published and in the Workspace - no parameter. I only want to choose a value from a test field, and all the conditions have been met per many posts and searches done. My users cannot use Desktop, they must use the published report. But without the parameter the report is now useless.