Overview

In the latest Cosmos updates there is a new and improved API endpoint to be used when connecting Power BI to Cosmos. This article will cover how to update your Power BI files to use the new endpoint. 

Details

Finding your Cosmos API URL

In the previous version of the Cosmos API, all users would connect using the following URL:

https://api.cosmosdatatech.com/odata

In the latest version of Cosmos, however, we have introduced the concept of Environments which now needs to be taken into consideration when connecting to the API. This way Power BI knows which environment to pull from. The new URL format for connecting Power BI to Cosmos is:

https://platform.cosmosdatatech.com/v1/environments/<environment id>/data

The <environment id> will be visible in the URL for the Cosmos Portal, for example:

You can log in to your Cosmos Portal, copy your enviroment ID out and replace it in the URL above, for example:

https://platform.cosmosdatatech.com/v1/environments/da6c982f-6997-4894-6d14-08ddd47afc90/data

Updating Your Power BI Reports

You will want to open each of your Power BI reports and click the bottom part of the Transform Data button and click Data Source Settings:

You can then click on the old data source (https://api.cosmosdatatech.com/odata) and click the Change Data Source button. On the next screen you can then paste in the URL that includes your environment ID and click Ok. 

This should update all data sources to point to the new URL. You would then publish your Power BI report for those changes to take effect.