Select Page

In The Trenches

With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS

Follow @gilra Last week Microsoft released a preview of the Template Apps – A new experience that was designed for partners and ISVs to deliver streamlined analytics to their clients. By now, you should be able to install or create template apps. You can learn about my early experience here, and read about the official […]

This post first appeared at https://datachant.com/2019/02/20/template-apps-in-power-bi-2/. The author is Gil Raviv

Read More

Read More

We were recently building a data model with on-prem Dynamics data mostly using the OData feed (v8.2).  This article only scratches the surface of what is possible with OData (including update/write functions and much more complex queries than those shown… This post first appeared at https://powerpivotpro.com/2019/02/some-odata-tips/. The author is Patrick MahoneyRead More

This post first appeared at https://powerpivotpro.com/2019/02/some-odata-tips/. The author is Patrick Mahoney

Read More

Read More

Data is most valuable when it leads to informed action. Making it easier for people to get actionable insights is what Power BI is all about. Now, with Power BI Template Apps, users can immediately begin exploring, learning, and taking action on key data with off-the-shelf apps. Template Apps are integrated packages of pre-built Power […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/insights-made-easy-with-power-bi-template-apps/. The author is 

Read More

Read More

Updated Feb 2019.  This is an edited version of my original article which first appeared on my site in Feb 2016. The rate of change in the tools available to a Business Analyst has never been faster than it is today.  The market is changing so quickly that many Business Analysts (BAs) are only just […]

This post first appeared at https://exceleratorbi.com.au/the-best-training-for-business-analysts/. The author is Matt Allington

Read More

Read More

Since I started focusing primarily on Microsoft BI/DW/analytics around 2005, I’ve always been happy being a generalist within that space. Fast forward to around 2017 when I started focusing predominantly on Azure. Being a generalist (still within BI/DW/analytics) in Azure is really tough — as I’m sure you well know. Not only is the variety […]

This post first appeared at http://feedproxy.google.com/~r/SqlChick-MelissaCoates/~3/D8AwdHjLT8I/keeping-up-with-azure-changes. The author is Melissa Coates

Read More

Read More

Yet more evidence that Power Query is taking over the world: there’s a new Power Query data source for SQL Server Integration Services in the latest version of SSDT. Here’s the blog post announcing it (the actual announcement is halfway through): Deeper integration and new connector for SSIS in ADF This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/gEMOe6lOnKM/. […]

This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/gEMOe6lOnKM/. The author is Chris Webb

Read More

Read More

Today Gartner released the 2019 magic quadrant for Business Intelligence.  As expected (by me at least), Microsoft is continuing its trail blazing and now has a clear lead over Tableau in both ability to execute and completeness of vision.  I thought it would be interesting to see a trend over time for the last 5 […]

This post first appeared at https://exceleratorbi.com.au/extract-numerical-data-points-from-an-image/. The author is Matt Allington

Read More

Read More

For the third straight week, we’re delivering on the item I’ve heard more end-user feedback around than any other we’d promised to deliver in the October blogpost.  At long last, you and your users will be able to export their Power BI reports to either PDF or PowerPoint and have their selections on the screen […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/end-user-filtered-export-capabilities-now-available/. The author is 

Read More

Read More

As part of our strategy to converge enterprise and self-service BI on Power BI as a single platform, we announced the public preview of incremental refresh last summer. While there is still more work to be done to get it to general availability, we have seen strong uptake of incremental refresh. Incremental refresh is a […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/incremental-refresh-query-folding/. The author is 

Read More

Read More

  We’re very grateful to our customers, our community members, and our partners for making Power BI what it is today.   Thank you.   The Power BI Team       Get the 2019 Gartner’s Magic Quadrant for Analytics and Business Intelligence Platforms report* to learn more.             *This graphic […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/microsoft-a-leader-in-gartners-magic-quadrant-for-analytics-and-bi-platforms-for-12-consecutive-years/. The author is 

Read More

Read More

January was a feature-filled month for the Power BI team! We kicked off this new year by announcing some of the highly requested features by our community and couldn’t have wished for a better start. We hope you’re just as excited for what’s to come for the rest of 2019! To recap, here’s a list […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-service-and-mobile-january-feature-summary/. The author is 

Read More

Read More

With the Power BI craze that kicked into high gear in 2017, it’s less common to be working in PowerPivot in Excel. However, during one of my recent remote consulting calls, one of our many clients needed some help with… This post first appeared at https://powerpivotpro.com/2019/02/an-oldie-but-goodie-powerpivot-in-excel-existing-data-connections/. The author is Krissy DyessRead More

This post first appeared at https://powerpivotpro.com/2019/02/an-oldie-but-goodie-powerpivot-in-excel-existing-data-connections/. The author is Krissy Dyess

Read More

Read More

The February 2019 release of Power BI Desktop includes some new functionality not mentioned in the summary blog post, functionality that is already in the latest Excel 365 builds (thanks Ed Hansberry for pointing this out) and will be extremely useful. It takes the form of four new options under the Split Column button in […]

This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/mwP52400jMg/. The author is Chris Webb

Read More

Read More

Matt here.  The blog article this week was written by Neville de Sousa.  Neville shared with me a Power BI report that shows all the Power BI features released since July 2015.  Neville will explain the background and his report. Neville:  Keeping track of Power BI Desktop’s amazing features since it went GA is difficult, […]

This post first appeared at https://exceleratorbi.com.au/power-bi-features-reporting/. The author is Neville de Sousa

Read More

Read More

The February update for Power BI Desktop has a preview of our new Key Influencers visual, which lets you perform key drivers analysis over your data with just a few clicks. We also have some major updates for Q&A with the addition of auto-generated questions and the ability to ask Insights related questions. Our partners […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2019-feature-summary/. The author is 

Read More

Read More

Take a look at the new version of Power BI Premium Capacity Metrics app.  In addition to comprehensive refresh , query and eviction metrics for past 7 days, the latest version now offers system metrics by workloads, and total active dataset size in memory metrics. In addition to demoing this latest version, Power BI program […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/webinar-2-12-tour-of-the-new-power-bi-premium-capacity-metrics-app-by-swati-gupta/. The author is 

Read More

Read More

Working out how long a Power Query M query takes to run – the first step to troubleshooting refresh performance problems in Power BI or Excel – is something I have blogged about several times (see here, here and here for example). However, there are problems with all of these methods such as the need […]

This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/K2L4qBXmRgY/. The author is Chris Webb

Read More

Read More

Follow @gilra Today Microsoft released a preview of the Template Apps – A new experience that was designed for partners and ISVs to deliver streamlined analytics to their clients (If you still don’t see this new experience, don’t worry – I was told by Microsoft that it will take couple of days to be fully […]

This post first appeared at https://datachant.com/2019/02/08/template-apps-in-power-bi/. The author is Gil Raviv

Read More

Read More

As the volume and complexity of the data continue to grow exponentially, organizations need an analytics solution that is fast, secure, and easy-to-use, so they can extract critical insights from their data and take timely actions to maintain a competitive advantage. Power BI and Azure provide customers an unmatched combination for petabyte-scale analytics – we […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/petabyte-scale-analytics-with-power-bi-and-azure/. The author is 

Read More

Read More

Recently, I was helping someone on Power BI community forum on the issue of calendar over run while comparing values with last year’s data. I thought it would make a good article to share with others. The Problem I will illustrate the issue using the AdventureWorks database (I need to make some tweaks to do this).  […]

This post first appeared at https://exceleratorbi.com.au/calendar-over-run-while-comparing-last-years-data/. The author is Matt Allington

Read More

Read More