Hello,
I have a BAQ I’d like to turn into a report that downloads to Excel. Right now I am just copying from the BAQ Designer and pasting into an Excel sheet, but I want users to be able to find it in the menu and have it download as an Excel file. How would I go about doing this?
Thank you!
You could create a new Report/Report Style where the data source in the Report Data Definition is that BAQ. Then you would be able to create a menu where your users can run that report.
You could call the BAQ from within Excel using Power Query and the REST APIs then you can pivot, create metrics etc.