Select Page

In The Trenches

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

Today, we’re excited to announce the public preview of the “new look” now available on Power BI Mobile.  We’ve refreshed our app and introduced new experiences, adding a home page that provides quick access to your commonly used content, and new navigation bars that give you an easy way of navigating through the app. With […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-power-bi-mobile-apps-new-look-preview/. The author is 

Read More

Read More

If you’re a Power BI fan there are three possible answers to the question “Did you know that the second edition of The Definitive Guide To DAX has just been published?”: Answer#1: Yup, I’ve already got my copy! This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/r1IUcB9_JBo/. The author is Chris WebbRead More

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

Read More

Read More

Earlier this month my template app Facebook Pages – Basic Analysis was featured here in Microsoft’s official monthly feature summary for Power BI Desktop. I would like to thank the 3,798 users who installed it so far and to Microsoft Power BI team who featured my work and are allowing us every day to generate […]

This post first appeared at https://datachant.com/2019/08/30/1-power-bi-template-app-on-appsource/. The author is Gil Raviv

Read More

Read More

Last week I attended Summit Australia in Melbourne. Summit Australia is a conference that focuses on the same products as the larger Microsoft Business Applications Summit (held this year in Atlanta). The majority of delegates … Use Microsoft Flow to Notify of New Files in a Folder Read More This post first appeared at https://exceleratorbi.com.au/use-microsoft-flow-to-notify-of-new-files-in-a-folder/. The […]

This post first appeared at https://exceleratorbi.com.au/use-microsoft-flow-to-notify-of-new-files-in-a-folder/. The author is Matt Allington

Read More

Read More

“New Feature Friday” returns as we’re thrilled to introduce support for URL parameters for paginated reports in the Power BI service.  This post first appeared at https://powerbi.microsoft.com/en-us/blog/url-parameters-for-paginated-reports-are-now-available/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/url-parameters-for-paginated-reports-are-now-available/. The author is 

Read More

Read More

We are pleased to announce the first release candidate of SQL Server 2019 Reporting Services is now available in the download center.   This post first appeared at https://powerbi.microsoft.com/en-us/blog/whats-new-for-sql-server-2019-reporting-services-rc1/. The author is Read More

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

Read More

Read More

Users of on-premises Analysis Services will know that most of the useful server properties can be set in SQL Server Management Studio, some (such as MaxIntermediateRowsetSize) can only be set by editing the msmdsrv.ini file. How do you set these properties in Azure Analysis Services though, when there is no msmdsrv.ini file to edit? The […]

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

Read More

Read More

We are excited to announce RC1 of SQL Server 2019 Analysis Services (SSAS 2019). The SSAS 2019 release is now feature complete! We may still make performance improvements for the RTM release. RC1 introduces the following features: This post first appeared at https://powerbi.microsoft.com/en-us/blog/whats-new-for-sql-server-2019-analysis-services-rc1/. The author is Read More

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

Read More

Read More

As we rolled out the preview of Shared Datasets and the new Build permission, we received feedback that our limitations on export of summarized data from a visual are overly restrictive. We are adjusting our approach based on your feedback. Specifically, we will allow users with the Read permission to export summarized data from a visual.  This post first appeared at https://powerbi.microsoft.com/en-us/blog/change-to-summarized-data-export-behavior-with-build-permission/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/change-to-summarized-data-export-behavior-with-build-permission/. The author is 

Read More

Read More

Today, I am thrilled to announce the release of custom branding for the Power BI service. Now you can change the look and feel of the Power BI service to match your corporate theme with just a few clicks! This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-custom-branding-for-your-organization/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-custom-branding-for-your-organization/. The author is 

Read More

Read More

One common requirement I have come across a few times is to limit a Power BI visual to only show completed months and exclude the current active month. This is common if you load data … Dynamically Show Completed Months in Power BI Read More This post first appeared at https://exceleratorbi.com.au/dynamically-show-completed-months-in-power-bi/. The author is Matt AllingtonRead More

This post first appeared at https://exceleratorbi.com.au/dynamically-show-completed-months-in-power-bi/. The author is Matt Allington

Read More

Read More

Following on from my last two posts on Power Query performance, I thought I would write about another trick that can make a big difference to your query execution times. It’s actually something that Ehren from the dev team mentioned in a forums thread that I blogged about here but it deserves to be better […]

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

Read More

Read More

August release of Gateway This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-august-2019-update-is-now-available/. The author is Read More

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

Read More

Read More

Our August release has another hotly anticipated feature from the Microsoft Business Application Summit, grouping. Grouping in reports, similar to PowerPoint’s grouping, lets you easily organize groups of visuals to move and resize them as a set. This month’s release also has some updates to our newest features, such as a  icon set picker for […]

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

Read More

Read More

A few weeks ago I wrote an article about the Power BI Icon feature released in July 2019. You can read that article here https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/ There were 2 common questions/themes coming from readers’ comments, and … Power BI Icon Names Read More This post first appeared at https://exceleratorbi.com.au/power-bi-icon-names/. The author is Matt AllingtonRead More

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

Read More

Read More

Power BI Mobile team partnered with Azure Active Directory team to integrate Power BI mobile applications with Azure Active Directory (AAD) Application Proxy to connect to Report Server from their mobile app, without the need to setup complex on-premise configuration. This post first appeared at https://powerbi.microsoft.com/en-us/blog/access-on-prem-report-server-from-your-power-bi-mobile-app-with-azure-active-directory-application-proxy/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/access-on-prem-report-server-from-your-power-bi-mobile-app-with-azure-active-directory-application-proxy/. The author is 

Read More

Read More

Five new Power BI Premium Capacity settings are available in the portal , preloaded with default values. Admin can review and override the defaults with their preference to better protect their capacity from running into issues and avoid problems before they arise. This post first appeared at https://powerbi.microsoft.com/en-us/blog/five-new-power-bi-premium-capacity-settings-is-available-on-the-portal-preloaded-with-default-values-admin-can-review-and-override-the-defaults-with-their-preference-to-better-fence-their-capacity/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/five-new-power-bi-premium-capacity-settings-is-available-on-the-portal-preloaded-with-default-values-admin-can-review-and-override-the-defaults-with-their-preference-to-better-fence-their-capacity/. The author is 

Read More

Read More

In part 1 of this series – which I strongly recommend you read before reading this post – I showed how removing columns from a table can make a dramatic improvement to the performance of certain transformations in Power Query. In this post I’ll show some tricks taught to me by Curt Hagenlocher of the […]

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

Read More

Read More

It’s time again to recap the major features and announcements we made in the Power BI service and mobile for the month of July. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-service-and-mobile-july-2019-feature-summary/. The author is Read More

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

Read More

Read More

With the public preview available for “Multi-Protocol Access” on Azure Data Lake Storage Gen2, now AAS can use the Blob API to access files in ADLSg2. Check how to do it! This post first appeared at https://powerbi.microsoft.com/en-us/blog/connecting-azure-analysis-services-to-azure-data-lake-storage-gen2/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/connecting-azure-analysis-services-to-azure-data-lake-storage-gen2/. 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

Top Posts & Pages

Blogroll