Can someone help me integrate Creatio with Power Bi, please?
How do Authenticate in Power Bi? I'm using Basic which works in Postman
Like
Hello Nicola,
First of all, select OData for your data source type, not Web content (web content won't perform the authentication the way that is needed for the OData auth challenge). Secondly, for some reason, I can't get Power BI to connect to Creatio's OData 4 endpoints (although I've not tried much with OData 4 in Power BI yet). However, when using the OData source type, I can connect to Creatio's OData 3 endpoints. Try using the following endpoint instead:
https://rdrive.creatio.com/0/ServiceModel/EntityDataService.svc/ContactCollectionRyan
Ryan Farley,
Thank you for the suggestion, unfortunately I can't get this to work either.
I have been having difficultly using Odata3 as a whole and have only been able to use OData4.
Even using web browse I have no results with OData3, I have added screen shots of the results for both Power Bi and Browser.
However I was able to authenticate through PostMan, but not go much further as I haven't had much exposure to PostMan.
I can retrieved results from the Browser using OData4, but unable to authenticate In Power Bi. Also attached Results.
I can't quite seem to get it all joined up, and I need to bring Data into our existing BI analytics.
Any suggestions on what I could be doing wrong would be greatly appreciated.
Many thanks
Nicola
Hi Nicola Wall,
Could you please provide Postman results and specify if another authentification through OData was successful? Any additional details on the issue are appreciated!
Also, could you please double-check the HTTP request that nothing is missed?
Regards,
Anastasiia