Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Looking for suggestions to import real time orders data from demandware (Salesforce commerce cloud).
Leads on importing data using OCAPI (Open Commerce API) into Power BI.
Thanks in advance!
Solved! Go to Solution.
Hi @shannoy_g10x ,
You can use the Web connector to connect to Salesforce by OCAPI directly if it has the api key.
Please refer the official document: Getting started with OCAPI 20.8
In addition, you can try to use Salesforce connector which is built in power bi desktop or try to use Rest API by the Web connector to connect to the data source.
Refer:
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @shannoy_g10x ,
You can use the Web connector to connect to Salesforce by OCAPI directly if it has the api key.
Please refer the official document: Getting started with OCAPI 20.8
In addition, you can try to use Salesforce connector which is built in power bi desktop or try to use Rest API by the Web connector to connect to the data source.
Refer:
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 8 | |
| 7 |