Scheduling Possibilities?

[sx200n]

Hello,

I have Power BI Pro installed as part of our E5 license and I am trying to evaluate it in thoughts of using it instead of our current IBM Cognos setup (that we pay extra for) fo rquerying our SQL server tables...

However, the one concern I have that I do not think Power BI can do - but would like clarification - is weather it will allow me to schedule CSV or excel file outputs of the reports at a given time.

Currently in Cognos I can make the query and save it, then script it all to run and export in whatever format I want and at whatever scheduling interval I need.

But I cannot see if Powre BI does this? If not, what other Microsoft product would be needed for SQL server extract scheduling? SSRS? SSMS?

 

[Matt Allington]

Power BI cannot do this, but there are various options. One question though - why do you need to do this? Maybe you don’t need to do this at all with power BI? You could definitely use power pivot for Excel to do this (Or Power query for Excel), and you could even automate it using VBA and the scheduled tasks tool in windows.

 

[sx200n]

Matt, thanks. That could be the answer.

Basically we have third party partners that been text file or csv file outputs to go to them so they can upload our raw data into their own systems.

Our Cognos system is old and slowly becoming incompatible with features in Windows 10 and I was hoping for a similar one solution replacement, but mixing Power Bi with scheduling some vbs scripts in Windows scheduler could be the answer.

Thanks