Forum Discussion

johnal67's avatar
johnal67
Contributor
4 months ago
Solved

Dimension Descriptions Extract

I need to automate a process of Extracting certain Dimension Descriptions into a Comma Delimited text file for exporting into PowerBI.  The application extract puts it into an XML format, and I need ...
Metadata
  • DanielWillis's avatar
    DanielWillis
    4 months ago

    Not too much effort involved to create a business rule to export to the File Explorer. There are API functions, method data adapters (i think) , and SQL tables to return meta-data information which you can then export. You can even stick a button on a dashboard to make it easier to run.

    You can also expose a data adapter using a REST API for PowerBi if you want to level it up.

    I haven't gone into much detail because I think there must be a lot of information already in these forums/docs on this but if you're stuck somewhere then happy to add more detail.

DanielWillis's avatar
DanielWillis
Valued Contributor
4 months ago

Not too much effort involved to create a business rule to export to the File Explorer. There are API functions, method data adapters (i think) , and SQL tables to return meta-data information which you can then export. You can even stick a button on a dashboard to make it easier to run.

You can also expose a data adapter using a REST API for PowerBi if you want to level it up.

I haven't gone into much detail because I think there must be a lot of information already in these forums/docs on this but if you're stuck somewhere then happy to add more detail.