SAP BW Bex Query With Structure Not able to pull into PowerBI?

[Anmolgan]

I cannot pull the fields that are required to build the report in SAP BI, In my case I can see the fields but there are 500+ field and its getting difficult in my case for selecting fields which are required as per material group or customer group, I enabled the characterstics structure but its reducing the amount of fields pulled in but its not giving me the correct output, the BEx query which I have contains conditions and certain strucutre which is defined, Is there any alternative or any other workaround to get past this issue?

[Anonymous]

Tick the checkbox "Enable characteristic structures" in Advance Options of Data source settings as below:

 

Regards, 

Kshi.teesh

[v-frfei-msft]

Hi @Anmolgan ,

Is that possible to filter data by Advanced option?

[Anmolgan]

I am trying to filter the data by putting it inside the tables but its giving me blanksnin places, plus data mismatch is there how can I.reduce all this?