Power BI API Connector to Obtain Workspace Data and on Dashboard, provide Guide to Component Relationships in it

Julesdude

Board Regular
Joined
Jan 24, 2010
Messages
197
Hi all,

I'm using the Power BI API mez file, available on Github, to allow me the connector to work with data from my Workspaces.

I'm trying to discover the best way of listing a table, perhaps a Matrix table, allowing the user to be able to identify all the sources and relationships within a component of a particular workspace - be it a source, dataflow, data set, report etc. The ultimate aim is to provide the BI Developer with an overview of what will change at B and C if something is changed at A.

The workspace tables available through the Power BI API connector provide unique IDs for the components in table format, alongside the name of that component. When you load all these in to Power BI, the Data Model view links these tables automatically but I'm wondering what the best approach would be for the output.

Any help appreciated.
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Forum statistics

Threads
1,223,902
Messages
6,175,278
Members
452,629
Latest member
SahilPolekar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top