Tip #464: Connecting PowerBI to CRM Online

Don’t be a literal as me and make this same mistake when setting up a connection to CRM Online for PowerBI. Read the fine print!

See how in the example there is no trailing space to include in the oData service endpoint!

oData Service Endpoint

oData Service Endpoint

You will get an error when you copy and paste the URL from the developer resources window from CRM. PowerBI doesn’t like the trailing space at all. It will say it can’t find the endpoint. Remove the slash before or after pasting it in and clicking on OK.

CRM Developer Resources

CRM Developer Resources

Leave a Reply

Your email address will not be published. Required fields are marked *