How to automate printing report to pdf

[GoingIncognito]

Is there any ideas how to automate printing repots to pdfs? Available tools include PBI (pro and premium capacity), PBI report service, and SQL Server licensing. So could possibly done as SSRS also. Or is there any way of automating PBI printing in SQL server - for example in SSIS job?

Thanks!

[wlinley]

Hi @GoingIncognito 

If you want to put a Power BI dashboard into PDF format there is an option for users to do this under "Export".

Automatically printing something from SSRS is a different kettle of fish...

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/3742a289-b635-41f6-853c-a09eee596b4a/best-w...

[GoingIncognito]

What I want to accomplish is automating the task of printing out reports. What I am asking is how can I accomplish this? Possibilities are PBI and SSRS. PBI options include, but are not limited to, PBI Report Server. 

Thank you.

[wlinley]

My personal thoughts are

Send the report to a location using a SSRS subscription.

Set a chron job to print anything in the folder at a certain time.

Set a SSIS procedure to move the file so it is not printed again.

I would imagine there is a slicker way to do this but this is the only way i can think off hand.