Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.