how to connect sap bw query in power bi

[Anonymous]

Hello

I am new to power bi. Could you please let me know how to connect SAP BW queries in power bi and also how to connect SAP ECC in power bi.

[venal]

@Anonymous 

Adding to @v-xuding-msft post, please refer the "white paper" released by Product Group Team for SAP BW.

https://docs.microsoft.com/en-us/power-bi/desktop-sap-bw-connector#next-steps --> Power BI and SAP BW whitepaper

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

[v-xuding-msft]

Hi @Anonymous ,

For SAP BW, you could connect in the Desktop and then publish to service. There are documents that you could reference.

Use the SAP BW Connector in Power BI Desktop 

DirectQuery and SAP Business Warehouse (BW) 

For SAP ECC, it is not supported to connect directly in Power BI. To make Power BI better, you could vote up the idea to get it fixed quickly. 

I find a similar thread where the users have connected successfully. Maybe you could reference it and have a try.

https://community.powerbi.com/t5/Power-Query/How-get-data-directly-from-SAP-ECC/td-p/411305/page/2 

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.

[Anonymous]

Hi,

  Thanks for the reply.. you have taken Database Source as  SQL Server Database but i required datasource as ECC.. Could you please provide step by step process to connect SAP ECC to Power BI..

To connect SAP BW queries i have used direct query option in that am not able to see all reports under multiproviders or info cubes which i have created in SAP BW query designer. Could you please let me know how can i see all the BW queries?

Thanks so much in advance for your support..

Regards,

Rajesh