cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jacob29paul
New Member

SAP BW Query not visible in Navigator Screen of Power BI

Dear All,

 

I am trying to connect SAP BW query with that of Power BI. We normally do the "external access check" in SAP BW query and then the query is visible in Power BI.

 

However in one of our query, even after external check, the query is not popping up in Power BI. Can you help me with this?

 

regards,

 

Jacob

3 REPLIES 3
Anmolgan
Post Prodigy
Post Prodigy

Even 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?

v-chuncz-msft
Community Support
Community Support

@Jacob29paul,

 

Take a look at Use the SAP BW connector in Power BI Desktop (Preview) and check if Enable characteristic structures option helps.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Sam,

 

I tried this option, but still the BW query does not appear in the search option. This BW query has conditions/ exception aggregations.

 

regards,

 

Jacob

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!