Forum Discussion
Power BI Paginated Report Auto Delivery
Dear all, I'm facing some problems related to my Power BI paginated report. Suppose I have a shared dataset connecting to my database in Power BI. We are like an e-commerce platform. My data mode...
there are several ways to automate the delivery of your Power BI paginated report to each merchant:
One option is to use the Power Automate (previously known as Microsoft Flow) to schedule the delivery of the report. You can create a flow that runs daily and filters the report based on the store merchant and recent date, then exports the report to Excel or PDF and sends it to the respective store merchant's email.
Another option is to use the Power BI REST API to programmatically retrieve the report and export it in the desired format. You can write a script that filters the report based on the store merchant and recent date, exports the report to Excel or PDF, and sends it to the respective store merchant's email.