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 it into a comma delimited file. Any suggestions?
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.
