While trying to setup a PowerBI connection to one of our CRM Online instances I kept getting the same error over and over again as I repeated what turned out to be the same mistake.The instructions in the PowerBI setup was to go to CRM Online and get the service endpoint for the OData connection. So I navigated to the CRM instance, went to developer resources, copied the link as shown below and then pasted it into the dialog window for PowerBI. The issue is that even though the OData service url contains a trailing slash and that is how it works in the browser and programatically to retrieve the connection, PowerBI doesn’t like it and will return an ‘Unable to Connect’ error.It appears PowerBI doesn’t know to strip it out or otherwise deal with it.
Note how the OData url has a trailing space where the other endpoints don’t. This is what bit me.
This is the error you get when you paste the endpoint url into Power BI with the trailing slash.
So here is the culprit, don’t do like I did and be so literal and copy and paste the URL without deleting the trailing slash. BTW, try this experiment. Past the url into your browser without the trailing space and then hit return. Guess what, it regenerates with the trailing space.