The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi All,
I am creating a Power BI report using direct query connectivity. My requirement is to access the same SAP BW Bex variables in Power BI Service.
I can view the variables from Power BI desktop using "Edit Variables". Can someone please suggest on how to view the variables from Power BI Service.
Note: I have already enabled the below setting.
Thank you.
Hi @POSPOS ,
Thank you for engaging with the Microsoft Fabric Community. You are correct when using DirectQuery with SAP BW, you can access and modify BEx variables in Power BI Desktop through the Edit Variables option. In Power BI Service, the process is a bit different.
To view and interact with SAP BW BEx variables in Power BI Service, please ensure the following
Once published, users should see an Edit variables link in the Filter pane of the report in Power BI Service. This lets them select values for the BEx variables similar to the experience in Desktop, but through the Service interface.
FYI:
For more details, you can refer to Microsoft’s official documentation: Edit SAP variables in Power BI Service Microsoft Learn.
Link:Edit SAP variables in Power BI - Power BI | Microsoft Learn
Thanks ®ards
Yugandhar.
@V-yubandi-msft - Thanks for the details. All the below pointers are done but I still cannot see the edit variables option in the filter pane
@POSPOS ,
Thank you for confirming that everything is set up correctly, including DirectQuery mode, the Premium workspace, SSO, the updated gateway, and the setting that lets report readers change SAP variables.
Here are a few additional steps you can try.
1. The Edit Variables option in the filter pane may take about five minutes to appear after publishing the report.
2. Manually refresh the semantic model
3. This can help rule out any browser cache or session issues by opening the report in private/incognito mode or another browser.
Please let me know if it still isn’t appearing, and we can explore the next steps or submit a support ticket if necessary.
Regards,
Yugandhar.
Hi @V-yubandi-msft - We waited for 24hrs after republish and still did not show up "Edit Variable" in the filter pane.
Semantic model was also manually refreshed and we still cannot see the option.
Thank you.
Hi @POSPOS ,
If you still encounter the issue, please consider raising a support ticket for further assistance.
To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:
Regards,
Yugandhar.
Hello @POSPOS ,
Could you please confirm if you have already submitted a support request to Microsoft?
Thank you.
We just wanted to check with you have you raised a support ticket for this issue?
Thank you for your reply. When you have a moment, please consider submitting a support ticket for further investigation.