Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Edit Variable option greyed out using SAP BW source -Import query

Hi All, I am using SAP Business Warehouse Application Server to connect to SAP BEx querty using "import query" but the Edit Variable option is greyed out. Can someone please let me know how to enabl...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

When you say "Live Connection", are you referring to Direct Query?

But I have more than one query to be used in the report which is not possible with Direct query. Please suggest.

Thanks

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

Yeah, it is only supported to connect with Direct Query. (Sorry for my mistake. I will re-edit the answer.) After researched, there is not a workaround to edit variables with import mode.  You could submit your requirement into Ideas and vote it up to get the feature fixed quickly.

 

Reference:

https://docs.microsoft.com/en-us/power-bi/service-edit-sap-variables#requirements-for-sap-edit-variables

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.