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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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