Select Page

In The Trenches

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

Take this short survey to influence our plans for AI in Power BI This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-ai-survey/. The author is Read More

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

Read More

Read More

Follow @gilra The Microsoft Business Application Summit was a blast. If you missed it, you can now watch all the Power BI session recordings here, or get a great snapshot for the major new features on the FourMoo blog. This post first appeared at https://datachant.com/2019/06/13/powerquery-com-and-my-recorded-sessions-at-mbas-2019/. The author is Gil RavivRead More

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

Read More

Read More

The conference might be over, but there’s so much more in store! Get ready to transform your business with the latest in Microsoft Business Applications. Explore 200+ sessions, workshops, and keynotes from Microsoft Business Applications Summit, available now in the Power BI Community. This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-demand-now-full-session-lineup-from-microsoft-business-applications-summit/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-demand-now-full-session-lineup-from-microsoft-business-applications-summit/. The author is 

Read More

Read More

Take our quarterly survey to help us continue to improve Power BI. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-quarterly-survey-june-2019/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-quarterly-survey-june-2019/. The author is 

Read More

Read More

“Who, or what, is Paginated Report Bear?” I hear you ask. Well, he’s the breakout social media star of 2019, a furry YouTube sensation whose incisive interviews of members of the Power BI development team have become renowned for their deep technical content and insights into the Power BI roadmap. If you’re not watching his […]

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

Read More

Read More

Your Power BI model is fed by a data warehouse, and you’d like to make some reports, but now your Customer table has several entries for each customer instead of one. Then, you filter out the obsolete versions of customers,… This post first appeared at https://powerpivotpro.com/2019/06/how-can-i-get-a-lookup-table-from-a-slowly-changing-dimension-scd/. The author is Fred KaffenbergerRead More

This post first appeared at https://powerpivotpro.com/2019/06/how-can-i-get-a-lookup-table-from-a-slowly-changing-dimension-scd/. The author is Fred Kaffenberger

Read More

Read More

Level: Intermediate I was delivering some training last week for a customer in Sydney and they participants had an interesting problem where they needed to be able to report on a rolling time window.  Think of it a bit like Rolling 12 Months Sales, or average weekly sales over a rolling 4 week period, but […]

This post first appeared at https://exceleratorbi.com.au/solving-a-complex-time-problem-in-power-bi/. The author is Matt Allington

Read More

Read More

Today, we’re announcing general availability (GA) for cognitive services, Azure ML and the AI workload in Power BI Premium. The AI workload will now be enabled by default for all P-nodes, as well as nodes A3/EM3 and above, allowing the users of those capacities to use cognitive services in dataflows right away. A new workload […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-ai-premium-workload-cognitive-services-and-azure-ml-general-availability/. The author is 

Read More

Read More

As we kick off the Microsoft Business Application Summit with our amazing community at Atlanta, I wanted to share some exciting Power BI news as part of the event, including the June release of Power BI Desktop and the general availability of Paginated Reports in the service. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-new-ai-and-enterprise-features-for-power-bi/. The author is Read […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-new-ai-and-enterprise-features-for-power-bi/. The author is 

Read More

Read More

Hopefully, you are either enjoying the start of the Microsoft Business Applications Summit or watching all the exciting news and announcements on social media! To go along with all those other announcements, we, of course, also have a big update for our June update for Power BI Desktop. There are a lot of new features […]

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

Read More

Read More

Based on the technology used in SQL Server Reporting Services, Paginated Reports brings a new set of enterprise reporting capabilities to the Power BI service. It enables developers and BI professionals to create and distribute highly formatted, pixel-perfect reports right alongside their interactive Power BI content, becoming the first cloud BI solution that combines the […]

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

Read More

Read More

Template app general availability announcement and latest features This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-template-apps-general-availability/. The author is Read More

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

Read More

Read More

We’re happy to announce that the Power BI Mobile iOS app is now integrated with Siri shortcuts. Now, you’ll be able to just say “Hey Siri, open my report” and you’ll get the content you’re looking for.  Together with Siri shortcuts, we’re also introducing device level search (Spotlight) which allows you to easily search for, […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-siri-integration-with-power-bi-mobile-ios-app-preview/. The author is 

Read More

Read More

Recently I found I needed to remove all the HTML tags from some text in Power Query. I searched and found a great – if complex – function from Marcel Beug here, but I realised that since that post was written the Html.Table M function has been added to the language and that it makes […]

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

Read More

Read More

Book update

Jun 7, 2019 | Data Chant

Are you attending Microsoft Business Applications Summit next week? I hope you can join my session on Power Query and get a chance to win a print version of my book. We will run an automated raffle (using Power Query and Microsoft Flow) and give away 8 books during the session. And if you want […]

This post first appeared at https://datachant.com/2019/06/07/book-update/. The author is Gil Raviv

Read More

Read More

June gateway release This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-june-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-june-2019-update-is-now-available/. The author is 

Read More

Read More

We’re almost halfway through the year and what a great start it’s been to 2019! The Power BI team continued to deliver some of the most anticipated features in the month of May. We were also heads down planning for the Microsoft Business Applications Summit, where we look forward to connecting with many of you […]

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

Read More

Read More

It is very common to need to transform data from one “shape” to another “shape” before it can be used inside Power BI for analysis (although many beginners don’t realise this).   One such example is shown below, where the data in the table on the left hand side needs to be transformed into the table […]

This post first appeared at https://exceleratorbi.com.au/pivoting-text-data-using-power-query/. The author is Matt Allington

Read More

Read More

This blog post covers the latest updates for Power BI embedded analytics and Custom Visuals. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-april-may-update/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-april-may-update/. The author is 

Read More

Read More

In Power BI, every visual needs a title. Titles not only makes it easier to manage items in the selection pane, but also provide context when exporting data. Without a title, info is exported with a generic title of “Data.”… This post first appeared at https://powerpivotpro.com/2019/06/export-power-bi-data-with-date-range-in-title/. The author is Fred KaffenbergerRead More

This post first appeared at https://powerpivotpro.com/2019/06/export-power-bi-data-with-date-range-in-title/. The author is Fred Kaffenberger

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