Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Report Export to Excel based on Schedule (Email,Shared Path)

Hi , we are using SQL enterprise edition,with which PowerBI Report server onpremise Aug2018 version we are deploying dashboards and reports. here the way how SSRS reports output is scheduled to sha...
Report Server
Report Server and SQL version
Report Server On premises
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

Have you tried PowerBI Robots yet? It allows you to set a schedule (from minutes to a year) to automatically export Power BI reports as PDF files (and images as well) and send them as an email attachment, to a SharePoint library, File system or a generated URL so you can display it on any device. It's very similar to the solution you linked to but doesn't have the requirements you mentioned.

 

If you have any questions about it, feel free to ask. We're from the team who developed it.

 

Thank you

Anonymous's avatar
Anonymous
Not applicable
7 years ago

as said we dont want to move to cloud, any of our reports due to security.

i did go through this product as well not in depth,

please let me know whether this works with onpremise and direct query?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    Images and PDFs on PowerBI Robots are always generated locally, i.e., on the computer running the agent. The program doesn't currently support DirectQuery (you need to have your reports on Power BI Online), but our team is working on adding it in the next update. If you're not subscribed to the product's newsletter, we can contact you here once it's implemented.

     

    Best regards,

     

    The DevScope team