Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi Community,
I need your help!
When loading data from SAP BW to Power BI, users have the option to apply dynamic filters, that retricts data before being loaded into Power BI. This is an huge advantages, when working with queries containing a lot of data, and very user friendly for report developers, as no coding is required.
Above picture is taken from - https://learn.microsoft.com/en-us/power-query/connectors/sap-bw/navigate-query-objects
My question to you is: Is it possible to add similar pre-filtering options for Power Query editor, when loading data from SQL Server Analysis Services to Power BI?
Have a great day 🎉
Kind regards
Martin
Hi Olga,
Maybe I do not understand [Manage Parameters] proporly, but I do not see how they can be used to limit the size of imported data from Analysis Services to Power BI (Power Query Editor)?
Kind regards
Martin
Hi, create parameters in Power Query Editor,
Then go to the column needed to be filtered, add equals parameter. You can have different parameters where they can type in or choose from the list of values.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
8 | |
6 | |
6 | |
6 | |
5 |
User | Count |
---|---|
9 | |
9 | |
8 | |
6 | |
6 |