Managing larger Office365 document libraries

This morning I ran into an interesting problem.  We have an office365 document library we’re using as a small scale CMS, where users are contributing documents and editing the attributes of those documents.  PowerBI can then query the attributes in …..

Read More

DAX – Properly calculating YTD

This seems like it should be straight forward, but it’s not. The documentation on the TOTALYTD function is not great. Suppose I have a fact table with monthly revenue, and a standard date dimension.  The date dimension has a date …..

Read More

A couple powerBI notes

I’ve been working on a big powerBI dog and pony show lately, and have discovered a couple things in my haste.  (Not really when I want to be discovering them) Filtering over a summarize or crossjoin is a terribly inefficient …..

Read More

DAX modelling circular reference error

I’ve been working on a new power BI model this week, with the intent of showing historical attributes of work done over time.   So I end up with table OrdersPFMHistory which contains a key that indicates a state at a …..

Read More

A quick Datazen POC and review

Earlier this year, Microsoft acquired Datazen, keeping true to their strategy of services and devices.  I’ve had the fortune of trying out these new tools for a client of mine.  I’m going to quickly cover how to set up a …..

Read More

The value of little data

This week I attended a tableau showcase.  I enjoy attending these events, not for information on the product, rather for information on which way the industry is moving.  This event showcased several Tableau customers, namely Alberta Health Services (AHS), Groundswell …..

Read More
1 2 3
Far better an approximate answer to the right question, which is often vague, than the exact answer to the wrong question, which can always be made precise. -John Tukey
The plural of anecdote is not data. - John Myles White

Recent Posts

RSS PowerBI blog

  • New Power BI Premium summary and workload metrics available in the admin portal April 22, 2019
    We have rolled out a new high-level summary metrics experience in the Power BI Admin Portal . This new experience replaces the four summary tiles you previously saw : CPU, Memory thrashing, Memory usage and DirectQuery with wide range of metrics measuring the summary of usage in the last 7 days to better portray the health […]
  • Live now, full session catalog for Microsoft Business Applications Summit 2019 April 22, 2019
    Time to get excited – the full session catalog for Microsoft Business Applications Summit is here. Explore every breakout session and workshop coming to the conference, taking place in Atlanta, Georgia June 10 – 11, 2019. Get ready to flex your skills – and build new ones – with all things Power BI and beyond. […]
  • E-Mail Subscriptions for Paginated Reports is Now Available April 19, 2019
    E-mail subscriptions is one of the key features used by millions of SQL Server Reporting Services customers today. Our latest release for “New Feature Friday” is the support of Paginated Reports in e-mail subscriptions in Power BI. Now, for the first time, you can schedule an e-mail subscription with a PDF attachment of your full […]