Automate Power BI Data Refresh to Sage Line 50 (or Other Sources) via Microsoft Query with Powershell, Task Scheduler and Excel Continue reading Power BI 'How To' Blog Number One
tag Data Services
Want to trigger reports to run when the data warehouse load completes? Here's how. Continue reading Daisy Chaining SDS Jobs and Report Services
Best known for being very easy to get started, you might expect it to be skin deep. Not so; not only is graphical modelling environment very powerful, its DAX (data analysis expressions) formula language has a rich set of powerful functions. Continue reading Cool Things About Power BI
Connecting to data stored in Excel spreadsheets or other file sources is great for prototyping Power BI dashboards, gaining quick insight and showing others what the tool can do. Continue reading Options for Connecting Power BI Dashboards Directly to Source Systems
I find myself starting this blog, sad that I must write it. When it comes to development languages and products I am without a shadow of a doubt firmly two feet and all other associated body parts stood plum on the centre of the Microsoft camp; this has been the case since my late 20’s when I started in software. The only real difference now is that there’s a lot more of me to fit inside the camp nowadays but fit I still do. Continue reading Dimensional Drift
