Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear All,
I have created a Report in Power Bi Desktop using direct query onption with my BW live connection.
That Report I have placed in my workspace but when I open Power Bi app and try to access the report there it doesnot get refresh.
Can anyone tell me how do I connect to my BW system.
Thanks
Solved! Go to Solution.
Hi @Anonymous ,
Please try below steps:
1. Install Implementation 2.0 SAP Connector in your computer
2.Create a new connection to use Implementation 2.0 of the SAP BW Connector. To create a new connection, take the following steps.
Select Get data. Select either SAP Business Warehouse Application Server or SAP Business Warehouse Message Server, and then connect.
In the new connection dialog, select the implementation. Selecting 2.0 for Implementation, as shown in the following image, enables Execution mode, Batch size and Enable characteristic structures.
3. Maybe you need to install the Power BI Gateway, it depends on whether the Power BI Service could access the data source .
For more details, you can read related document: Use the SAP Business Warehouse (BW) Connector in Power BI Desktop - Power BI | Microsoft Learn , Guidance for deploying a data gateway for Power BI - Power BI | Microsoft Learn
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Please try below steps:
1. Install Implementation 2.0 SAP Connector in your computer
2.Create a new connection to use Implementation 2.0 of the SAP BW Connector. To create a new connection, take the following steps.
Select Get data. Select either SAP Business Warehouse Application Server or SAP Business Warehouse Message Server, and then connect.
In the new connection dialog, select the implementation. Selecting 2.0 for Implementation, as shown in the following image, enables Execution mode, Batch size and Enable characteristic structures.
3. Maybe you need to install the Power BI Gateway, it depends on whether the Power BI Service could access the data source .
For more details, you can read related document: Use the SAP Business Warehouse (BW) Connector in Power BI Desktop - Power BI | Microsoft Learn , Guidance for deploying a data gateway for Power BI - Power BI | Microsoft Learn
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |