Select Page

In The Trenches

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

In addition to the 20 tracks lead by the community, technical experts and Industry luminaries presenting at the upcoming Power Platform Summit in Amsterdam, the Microsoft Team will be there in full force presenting the Microsoft Power Series track– over 15 hours of deep dive and hands on content.  These sessions are included in both the  Power […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/connect-with-the-microsoft-product-team-in-amsterdam-at-power-summit/. The author is 

Read More

Read More

Today, we’re excited to announce that Power BI is making it easier for Azure AD B2B Guest users to collaborate with colleagues across organizational boundaries. Rolling out to production this week is a new capability that allows external Guest users to edit and manage content in workspaces, get the full home experience, and to do […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/azure-ad-b2b-guest-users-can-now-edit-and-manage-content-in-power-bi-to-collaborate-better-across-organizations/. The author is 

Read More

Read More

SQLBits is one of the best Microsoft data platform conferences around, and last week’s event in Manchester was particularly good. As usual, videos of almost all of the sessions are available for everyone to view for free online (no registration required) here: https://sqlbits.com/content/Event18 This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/X-NmO8LW5Ps/. The author is Chris WebbRead More

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

Read More

Read More

We are happy to announce the General Availability (GA) of Multi Geo for Power BI Premium! With Multi Geo going GA, you can extend your Power BI tenant to store your users’ data in the geographies covered in the Microsoft Trust Center, except for Power BI Germany, Power BI China operated by 21Vianet or Power […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-multi-geo-general-availability/. The author is 

Read More

Read More

The Power Platform World Tour is well underway with a huge success at Tampa, recently wrapped up its second stop in Silicon Valley, California and Washington DC and Chicago right around the corner. With 24+ breakout sessions covering topics across the entire Power Platform, expert speakers, and great conversations fueled by gallons of coffee, it’s […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/the-power-platform-world-tour-2-stops-down-endless-possibilities-to-go/. The author is 

Read More

Read More

Optimization has become one of my favorite topics. OK, I’ll admit it: it might be an obsession and a source of joy. My inability to optimize (queries, data models, and DAX) used to be a source of headaches and the… This post first appeared at https://powerpivotpro.com/2019/03/dax-optimizations-write-it-like-the-dax-calls-it/. The author is Matthew MowreyRead More

This post first appeared at https://powerpivotpro.com/2019/03/dax-optimizations-write-it-like-the-dax-calls-it/. The author is Matthew Mowrey

Read More

Read More

We have a 5-minute survey regarding the default theme color when you publish a Power BI app to your consumers. We’d love for you to tell us what your preference is for the default color preference and why that is important to you. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-app-theme-color-survey/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-app-theme-color-survey/. The author is 

Read More

Read More

I woke up Saturday morning to a lot of chatter and blog articles about an announcement that Microsoft made at SQL Bits.  Microsoft is adding “Calculation Groups” to the DAX language. There are a number of blogs already that talk about the announcement, including Chris Webb and The Italians, but I wanted to give my […]

This post first appeared at https://exceleratorbi.com.au/calculation-groups-are-coming-to-dax/. The author is Matt Allington

Read More

Read More

Get ready to flex your business applications skills – and pick up some new ones – at Microsoft Business Applications Summit. Coming to Atlanta, Georgia June 10 – 11, 2019, this is the place to dive deep with the tools you use every day, get a sneak peek at what’s new and next, and connect […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/unlock-next-at-microsoft-business-applications-summit-2019/. The author is 

Read More

Read More

Microsoft released the new Template Apps recently, and I am extremely happy to share my first App with you. It is publicly available on Microsoft AppSource. You can now explore Power BI Custom visuals via my Power BI Template App, and share it with your end-users in your organization for free from here. This post […]

This post first appeared at https://datachant.com/2019/03/04/template-app-custom-visuals-exploration-tool/. The author is Gil Raviv

Read More

Read More

In modern BI projects, understanding the flow of data from the data source to its destination, and understanding the data transformation done along the way, is a key challenge for many customers. This challenge becomes even bigger if you have built advanced analytical projects spanning multiple data sources, artifacts, and dependencies.  Questions like “What happens […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-data-lineage-experience-for-dataflows/. The author is 

Read More

Read More

With the release of CTP 2.3 of SQL Server 2019 today there was big news for Analysis Services Tabular developers: Calculation Groups. You can read all about them in detail in this blog post: What’s new for SQL Server 2019 Analysis Services CTP 2.3 This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/4-ReOjipweg/. The author is Chris WebbRead More

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

Read More

Read More

We are happy to announce that we have just released the February update for the On-premises data gateway (version 3000.1.257)                                          This month’s Gateway update includes an updated version of the Mashup Engine, which matches the […]

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

Read More

Read More

I was answering a question for a student in one of my online training courses this week. The question was, “Do you know of a way in power query to efficiently extract YYYY-MM from a Date column?” This can be done ‘manually’ with multiple steps including: Extract the Year into 1 column Extract the Month […]

This post first appeared at https://exceleratorbi.com.au/query-by-example-to-extract-yyyy-mm-from-a-date-column/. The author is Matt Allington

Read More

Read More

A new whitepaper authored by Peter Myers presents a comprehensive body of knowledge covering all aspects of deploying, scaling, troubleshooting and managing a Power BI Premium deployment in an enterprise. The whitepaper provides both background information explaiing  how various Power BI concepts play together in an enterprise deployment as well as practical examples of challenges encountered in […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-premium-deployment-and-management-whitepaper-added/. The author is 

Read More

Read More

A couple of people have asked me recently about how to ‘bone up’ on the new data lake service in Azure. The way I see it, there are two aspects: A, the technology itself and B, data lake principles and architectural best practices. Below are some links to resources that you should find helpful. Learning […]

This post first appeared at http://feedproxy.google.com/~r/SqlChick-MelissaCoates/~3/Uca8yuBnoKU/resources-for-learning-about-azure-data-lake-storage-gen2. The author is Melissa Coates

Read More

Read More

To ensure employee productivity and satisfaction with Power BI, enterprise organizations develop comprehensive product training, bolster their help desks, and invest in helping their user communities with internal forums to share ideas and best practices. But it can be a challenge to educate users about the availability of these organizational resources. The exciting news is […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/tailoring-help-and-support-for-power-bi-users/. The author is 

Read More

Read More

Business Problem: In a recent project with one of our clients, we were attempting to categorize website visit logs, based on the visitor’s landing page. The client had been maintaining a table of KeyPhrases that correspond with Categories. If the… This post first appeared at https://powerpivotpro.com/2019/02/powerquerymagic-conditional-joins-using-table-selectrows/. The author is Justin MannhardtRead More

This post first appeared at https://powerpivotpro.com/2019/02/powerquerymagic-conditional-joins-using-table-selectrows/. The author is Justin Mannhardt

Read More

Read More

Follow @gilra In today’s blog post, I share the generic solutions for the Fill Down challenge that I posted here. This post first appeared at https://datachant.com/2019/02/25/the-fill-down-hierarchies-challenge-3/. The author is Gil RavivRead More

This post first appeared at https://datachant.com/2019/02/25/the-fill-down-hierarchies-challenge-3/. The author is Gil Raviv

Read More

Read More

With our February update of Power BI, you can now share, publish and view Python visuals in your reports and dashboards. This update extends the support for Python in the Power BI Desktop to the Power BI service. This ability completes the support for Python in Power BI, enabling you to use Python scripts to […]

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