
Hello,
I am trying to find ways to connect or duplicate a report from Management Reporter for PowerBI. We currently use Management Reporter to generate some financials and we have a financial report in MR that we want to drive a PowerBI dashboard. Is there a way to run a report through SQL without having to schedule an export in MR?
There's not a way to run an MR report through SQL. The MR tables are so interconnected it would be nearly impossible to do. It's quicker to export the report to Excel and use the data from there. Same question was asked in the PowerBI forums and it doesn't look like there was success with connecting MR and PowerBI.