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
author Angus Menter
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
If you use a month name field (or convert a month number to name), it is a string object, so orders alphabetically in a report. The report users can change this with a custom sort but this is cumbersome. Continue reading Universe 'month name' Object That Orders Chronologically
