• Adam Thurgar

Power BI Desktop auto refresh

I really like what I have been able to do with my Power BI Desktop prototype. I have now extended its functionality to start a SQL Server scheduled job that sends me a summary report via email and then starts the database backup job. Everything is almost automated except that there is no way to automatically schedule a refresh, then save and publish from Power BI Desktop. It must be able to be done with some commands (clicking a button must action some command behind the scenes), but nobody seems to know what the commands are. I know that it can be done because there is that capability in the Power BI service. If I knew the commands I could put it in a batch file or powershell script and then schedule that. In these days of automating tasks, why can't Microsoft give us the basic tools to at least automate this component? At the moment I am using PBIXRefresher which mimics key strokes, it is not perfect - but its a start.

7 views0 comments

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t