Select Page

In The Trenches

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

The November update has major updates in several areas of Power BI Desktop. There’s a new, modern ribbon that aligns Power BI Desktop with Office and adds more functionality. We’re also adding a new visual, the decomposition tree, which is one of the most requested ideas on ideas.powerbi.com. AI functions integrated into Power Query allows […]

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

Read More

Read More

Last week in Orlando Florida, Microsoft held its annual Ignite conference. I have never been to Ignite but it is on my list of things to do in the future. There are always lots of … Microsoft Renames Flow to Power Automate Read More This post first appeared at https://exceleratorbi.com.au/microsoft-renames-flow-to-power-automate/. The author is Matt AllingtonRead More

This post first appeared at https://exceleratorbi.com.au/microsoft-renames-flow-to-power-automate/. The author is Matt Allington

Read More

Read More

Next in the Power BI community Triple A series: Ask Amir Netz questions about the latest updates, features and future. This post first appeared at https://powerbi.microsoft.com/en-us/blog/exclusive-live-community-event-2-ask-amir-anything/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/exclusive-live-community-event-2-ask-amir-anything/. The author is 

Read More

Read More

Among all the exciting announcements made at Ignite last week, one you may have missed (even in all the Excel-related announcements here) was that dynamic arrays have finally reached GA. Ever since they were announced I’ve been interested in how they can be used with Excel cube functions, which allow you to get data from […]

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

Read More

Read More

Embed paginated reports in your own application for your customers This post first appeared at https://powerbi.microsoft.com/en-us/blog/embed-paginated-reports-in-your-own-application-for-your-customers-preview/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/embed-paginated-reports-in-your-own-application-for-your-customers-preview/. The author is 

Read More

Read More

Over the past few weeks we have released several new features in Dataflows, allowing users to seamlessly ingest and prepare data that can be widely reused by other users across the Power Platform including lots of new Data Connectors, Data Transformations and other Power Query Online authoring enhancements. This post first appeared at https://powerbi.microsoft.com/en-us/blog/50-new-features-in-dataflows-this-month/. The author […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/50-new-features-in-dataflows-this-month/. The author is 

Read More

Read More

I stumbled across an interesting problem recently when helping someone on a forum. Here is the scenario. Assume there is a help desk that is logging tickets into a system. Each ticket is assigned to … Show the Tickets Assigned to Me (or Others) Read More This post first appeared at https://exceleratorbi.com.au/show-the-tickets-assigned-to-me-or-others/. The author is Matt AllingtonRead […]

This post first appeared at https://exceleratorbi.com.au/show-the-tickets-assigned-to-me-or-others/. The author is Matt Allington

Read More

Read More

We are excited to announce new data protection capabilities in Power BI that build on Microsoft’s strengths in security and enable customers to empower every user with Power BI and better protect their data no matter how or where it is accessed. Classify and label sensitive Power BI data using the familiar Microsoft Information Protection […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-new-data-protection-capabilities-in-power-bi/. The author is 

Read More

Read More

Our guest today is Kolyu Minevski, Director, Financial Management and Reporting at Fadata Group. You can contact him here. This article will demonstrate how Power Query can be used for maintaining a simple database/register. Traditionally Power Query is perceived as a tool for data extracting, cleaning and shaping for further analysis. In this case, its […]

This post first appeared at https://datachant.com/2019/11/04/guest-story-simple-database-power-query/. The author is Kolyu Minevski

Read More

Read More

Through community driven innovation and decades of enterprise BI excellence, Microsoft delivers amazing data exploration experiences and enterprise grade capabilities in Power BI. Today at Microsoft Ignite, we’re announcing the next wave of innovation that will allow organizations around the world to bring analytics to everybody through trusted, actionable new experiences. This post first appeared […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/weaving-business-intelligence-into-the-fabric-of-the-organization-with-microsoft-power-bi/. The author is 

Read More

Read More

Power BI introduces Enterprise Information Management capabilities, including data lineage and data protection, to help users manage and protect their data assets. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-enterprise-information-management-capabilities-in-power-bi/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-enterprise-information-management-capabilities-in-power-bi/. The author is 

Read More

Read More

We are excited to announce the public preview of large models in Power BI Premium. This enables fast user interactivity over large datasets. Until now, dataset caches in Power BI Premium have been limited to 10 GB after compression. Large models remove this limitation, so dataset cache sizes are limited only by the Power BI […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/large-models-in-power-bi-premium-public-preview/. The author is 

Read More

Read More

If you’re building DAX queries using Power BI Report Builder you might notice something that looks like a new DAX function called RSCustomDaxFilter. For example, here’s a simple DAX query built from the Adventure Works Tabular demo database, with one measure and one parameter built Calendar Year: Note that the “Enable Multi Value Parameters” option […]

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

Read More

Read More

The Power BI team are looking forward to meeting Ignite attendees at Microsoft Ignite in Orlando, FL. The Power BI team will be delivering new sessions with the latest guidance on new features and capabilities, and will be available for direct 1-1 conversations. If you’re coming to Microsoft Ignite be sure to come by and […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/learn-about-power-bi-at-microsoft-ignite/. The author is 

Read More

Read More

Power Platform admin center gateway management enhancements This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-management-by-region/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-management-by-region/. The author is 

Read More

Read More

I have written a series of articles where I explained different methods of combining data from multiple files into a single workbook/table using Power Query. In the first article, I explained how to create a … Combining Multiple Sheets from Multiple Workbooks Read More This post first appeared at https://exceleratorbi.com.au/combining-multiple-sheets-in-multiple-workbooks/. The author is Matt AllingtonRead More

This post first appeared at https://exceleratorbi.com.au/combining-multiple-sheets-in-multiple-workbooks/. The author is Matt Allington

Read More

Read More

The Power BI User Group (PowerBIUG) sat down with Montreal Power BI User Group members and winners of the Power BI User Group global hackathon, Team Hydro-Québec to learn more about them, what inspired their winning Power BI solution, and why being engaged with their local user group is so important. This post first appeared […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/from-newbies-to-global-hackathon-winners-power-bi-brings-user-skill-levels-and-confidence-full-circle/. The author is 

Read More

Read More

A special episode of the series Bad Practices in Power BI WARNING!! The following article contains images and Power BI bad practices that experienced Power BI users might find disturbing and inappropriate. Accordingly, reader discretion is advised. This post first appeared at https://datachant.com/2019/10/29/halloween-story-7-ways-to-kill-your-power-bi-model/. The author is Ruth Pozuelo MartinezRead More

This post first appeared at https://datachant.com/2019/10/29/halloween-story-7-ways-to-kill-your-power-bi-model/. The author is Ruth Pozuelo Martinez

Read More

Read More

Learn what cool new features are coming in the release a week before the rest of the world knows! This post first appeared at https://powerbi.microsoft.com/en-us/blog/live-sneak-peek-of-the-november-desktop-release-and-ama-with-amanda/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/live-sneak-peek-of-the-november-desktop-release-and-ama-with-amanda/. The author is 

Read More

Read More

This session will include a series of visualization and reporting techniques that you’ll be able to leverage in your company’s reports to take them to the next level. This post first appeared at https://powerbi.microsoft.com/en-us/blog/unlocking-new-visualizations-and-features-in-power-bi/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/unlocking-new-visualizations-and-features-in-power-bi/. 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