All posts in Business Intelligence

    Earlier this week I encountered a new Power Query error when I attempted to update a Power Query that I had previously created to load a Power Pivot model. Unfortunately, when queries are changed after a Power Pivot model is created, the underlying metadata does not automatically refresh. Read more

About every month or so a new group of students tour the Pragmatic Works office. They’re a part of the Pragmatic Works foundation, a non profit organization created to help unemployed, underemployed, and returning veterans gain the skills needed to gain access into the IT industry as database developers. I Read more

Have you ever created a report using a matrix with many row groups?  Unless you created a stepped report, you may have created a clumsy looking report with row groups spread out across many columns.  Fortunately, we can put multiple row groups inside the same column to create a clean Read more