Select Page

In The Trenches

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

This is the first blog post dedicated to Analysis Services on the Power BI blog. As discussed in this post on the old Analysis Services team blog, Microsoft is moving off MSDN and TechNet blogs. We have made it clear that Power BI will be a one-stop shop for both enterprise and self-service BI on […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/whats-new-for-sql-server-2019-analysis-services-ctp-3-0/. The author is 

Read More

Read More

We’re happy to announce our May 2019 update of Power BI Report Server! This release has many reporting features including conditional formatting for titles and other visual objects, the performance analyzer pane, accessibility support for visuals. The new modeling view is also featured in this release. Read on to learn more about the new features […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-update-may-2019/. The author is 

Read More

Read More

Dozens of Power BI visuals come out-of-the box with Power BI Desktop. These visuals are available in the visualizations’ pane when you create or edit Power BI content. These visuals are just the beginning of the available options to help you tell your data story. Learn about the variety of options you get with Power […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/how-to-govern-power-bi-visuals-inside-your-organization/. The author is 

Read More

Read More

If You’re Not Building Data Models, You’re Not Doing Power BI (or Data!) the Right Way Alternate Titles Abound! I could have just as easily titled this post ANY of the following: Why Power BI is (much) better than Tableau… This post first appeared at https://powerpivotpro.com/2019/05/data-models-power-bi-has-a-brain-how-about-your-bi-strategy/. The author is Rob CollieRead More

This post first appeared at https://powerpivotpro.com/2019/05/data-models-power-bi-has-a-brain-how-about-your-bi-strategy/. The author is Rob Collie

Read More

Read More

Level: Intermediate I have had a couple of requests for help during my live training classes and online training classes on how to build a Six Sigma Control Chart.  Now I am not professing to be a Six Sigma black belt, but I do know how to write DAX and I do know how to […]

This post first appeared at https://exceleratorbi.com.au/six-sigma-control-charts-in-power-bi/. The author is Matt Allington

Read More

Read More

We’re excited to announce the release of new app navigation experiences that give reporting teams the power to customize navigation for end users, so they can find content quickly and understand the relationships between different reports and dashboards. We’ve also sprinkled in several important new features to help app authors create supportable apps that delight […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/designing-custom-navigation-for-power-bi-apps-is-now-available/. The author is 

Read More

Read More

Jason Thomas and Gerhard Brueckl have both blogged on the subject of storing images as text inside a Power BI dataset: Embedding Images in Power BI using Base64 This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/-9QW2-6k-M0/. The author is Chris WebbRead More

This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/-9QW2-6k-M0/. The author is Chris Webb

Read More

Read More

What is the maximum length of a text value in Power BI? It turns out that this is a more complex question than you might think! The maximum length of a text value that the Power Query engine can load into a single cell in a table in a dataset is 32766 characters – any […]

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

Read More

Read More

We have an exciting release this month. On top of incremental improvements for several of our recent released features, such as the key influencers visual and our new filter pane, we also have a new performance analyzer pane. This new pane lets you get a behind the scenes view of what’s happening when your report […]

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

Read More

Read More

Microsoft Business Applications Summit June 10 – 11  in Atlanta, Georgia is almost here and you have one more reason to attend year…A chance to meet the community super stars.  We know, one of the primary reasons people go to conferences is to meet the presenters.  And at the Microsoft Business Applications Summit (MBAS), we have an entire “Ask […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/meet-community-stars-at-microsoft-business-applications-summit/. The author is 

Read More

Read More

We’re happy to announce one of our most commonly requested features for custom connector support in Power BI – Trusted Third Party Connectors. As it stands today, the only way that you can use a connector with the ‘Recommended’ security setting is for it to be signed and distributed by Microsoft. Unfortunately, this stops a […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/trusted-third-party-connectors-for-power-bi/. The author is 

Read More

Read More

I often get asked about measure tables during my Power BI online training classes. This post will discuss the merits of measure tables versus storing your measures in the table where the data comes from. What is a Measure Table? A measure table is a dedicated table used to store some or all of the […]

This post first appeared at https://exceleratorbi.com.au/measure-tables-in-power-bi/. The author is Matt Allington

Read More

Read More

Now that tax season is over, are you ready to see how your contributions are helping the government run?  As it did in 2017 and 2018,  USAFacts  published a 10-K Report using Microsoft Power BI to show a comprehensive view of US federal, state and local governments’ revenues and expenditures. The not-for-profit, non-partisan institute—funded by former Microsoft […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/through-power-bi-usafacts-explores-government-financial-data-in-latest-report/. The author is 

Read More

Read More

We can’t wait for Microsoft Business Applications Summit this year – and it’s almost here! Coming to Atlanta, Georgia June 10 – 11, this is your chance to get hands-on with your favorite tools, go one-on-one with experts and engineers, and collaborate with our vibrant community of data drivers.     Why Attend? Top 10 reasons to join us in June. Learn more about Microsoft’s […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/microsoft-business-applications-summit-top-10-reasons-to-attend/. The author is 

Read More

Read More

June 11-12 are getting near, and it is this time of the year to start getting excited. Microsoft Business Applications Summit is getting close. Do you plan to attend it? I will be glad to meet you in person in one of my sessions that will focus on my Power Query book and the development […]

This post first appeared at https://datachant.com/2019/05/13/my-sessions-at-mbas/. The author is Gil Raviv

Read More

Read More

April was packed full of new capabilities for Power BI. Thank you for the ongoing support and feedback – we couldn’t have done it without you. Here’s a quick rundown of everything we announced last month: Power BI dataflows GA Q&A update for dashboards New workspaces experience GA Paginated Report Builder New Power BI regions […]

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

Read More

Read More

One of the many big announcements at Build this week, and one that caused a lot of discussion on Twitter, was about Wrangling Data Flows in Azure Data Factory. You can read the blog post here: https://azure.microsoft.com/en-us/blog/analytics-in-azure-remains-unmatched-with-new-innovations/ This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/zgPeazvPG_8/. The author is Chris WebbRead More

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

Read More

Read More

The Power Platform User Groups (Power BI, PowerApps, and Flow) are excited to announce that they have added another stop to the Power Platform World Tour – They are headed to beautiful Vienna, Austria! We have several other stops planned in 2019 such as: London Madrid Copenhagen Sao Paulo Mexico City Vienna  Where would you […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/where-in-the-world-is-power-bi-world-tour-dates-locations/. The author is 

Read More

Read More

I am happy to announce the release of a new version of the Power BI free template app Custom Visuals Exploration Tool. Download it from AppSource here. Follow @gilra This post first appeared at https://datachant.com/2019/05/08/new-version-custom-visuals-exploration-tool/. The author is Gil RavivRead More

This post first appeared at https://datachant.com/2019/05/08/new-version-custom-visuals-exploration-tool/. The author is Gil Raviv

Read More

Read More

We are happy to announce that we have just released the May update for the On-premises data gateway (version 3000.5.185). Here are some of the things that we would like to highlight with this month’s release: Gateway Performance Monitoring (Public Preview) Amazon Redshift Refresh via the on-premises data gateway May version of the mashup engine […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-may-2019-update-is-now-available/. The author is 

Read More

Read More

Hansen BI brings you the latest insights from the most popular Microsoft Business Intelligence bloggers around the world

Blogroll