Power BI has finally brought in a feature that was much awaited by SAP data users who are also using Power BI for their reporting. Variables are one of the most important functionalities when it comes to end-users to filter their content before and after the report is generated.

To enable this feature, you will need to note that Power BI has some pre-requisites for this to work.

  1. You will need Premium capacity enabled for the workspace where the report/dashboard is placed.
  2. SSO needs to be enabled mandatorily.
  3. Must not have relational view enabled for SAP HANA.
Edit Variables for End Users in Power BI
  1. Enable the option for users to consume variables and change them on power bi service.
Edit Variables for End Users in Power BI
  1. Have the new Filter experience enabled.

Let’s now try creating a simple report having SAP variables enabled and consuming the variables in the end.

Edit Variables for End Users in Power BI

Push your report to Premium backed workspace

It is mandatory that we have Premium Workspace for this to work. Once the report is in the workspace, Open it. On the filters pane, we can see the edit variables. We will now be able to see the Edit Variables option in the Power BI Report.

Edit Variables for End Users in Power BI

You will now be able to select out all the variables that are placed with the report provider from the edit variables option in the filter screen.

Edit Variables for End Users in Power BI



Know more about Microsoft Power BI services offerings from Visual BI solutions here.

Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192


Copyright © Visual BI Solutions Inc.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Share This!

Share this with your friends and colleagues!