To connect Jedox to Power BI, you will need to follow these steps:
- Make sure that the oData Hub service is running. (check Cloud Console)
- Obtain the Jedox OData API URL: usually, add odata before the cloud name. Example https://odata.test-jedox4begginers.cloud.jedox.com/DATABASENAME. It is also essential to add a database name at the end. In our case, we will put Biker as a database.
- Connect to Jedox from Power BI: Here, click on the “Get Data” button in the Home tab, and select “OData Feed” from the list of available data sources.
- Paste the Jedox OData API URL into the “URL” field, and click “OK” to connect to the Jedox server.
- Add the username and password. Depending if your team is using SSO choose Windows or Basic for standard Jedox credentials.
- Import data into Power BI: Once connected to the Jedox server, you can select the Jedox cubes or views you want to import into Power BI. Select the cube or view from the list of available tables, and click “Load” to import the data into the app.
- Create reports and dashboards: With the Jedox data is now available.
Embed Jedox in Power BI
Another thing we can do is embed a Jedox report inside Power BI. In that way, we can also publish the planning reports.
- Click on My Workspace and + New
- Choose Dashboard
- Edit – > Add a tile
- Choose web content and add the following code to Embed Code
On this link you can learn how to create a link from your report and put it instead of this youtube link.
After clicking apply, you will see your Jedox report embedded inside the app.