Select Page

In The Trenches

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

Just a quick post to let you know that an interview I recorded for the BIFocal Show podcast at the Microsoft Business Applications Summit in Atlanta a few months ago is now available for your listening pleasure: Episode 117 – Interview with Chris Webb This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/2zbI3HgwUEs/. The author is Chris WebbRead More

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

Read More

Read More

Welcome back to another “New Feature Friday” for Paginated Reports in the Power BI service.  We’re pleased to announce three new features rolling out around paginated reports. This post first appeared at https://powerbi.microsoft.com/en-us/blog/paginated-reports-in-power-bi-september-2019-feature-summary/. The author is Read More

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

Read More

Read More

On 2 October I will be hosting a free webinar called “Introduction to DAX for Power BI”. I have trained literally thousands of people on the DAX language through my books, online training and live … Free Webinar: Introduction to DAX for Power BI Read More This post first appeared at https://exceleratorbi.com.au/free-webinar-introduction-to-dax-for-power-bi/. The author is Matt AllingtonRead […]

This post first appeared at https://exceleratorbi.com.au/free-webinar-introduction-to-dax-for-power-bi/. The author is Matt Allington

Read More

Read More

This is What I Want (What I Really Really Want): Zeroes to Rank Poorly. Divide by Zero Errors to Display “N/A.” And “N/A” to NOT participate in my ranking. RANKX: the Mother of Many Blog Posts Ya know, we could… This post first appeared at https://powerpivotpro.com/2019/09/a-brief-treatment-of-divide-rankx-and-n-a/. The author is Rob CollieRead More

This post first appeared at https://powerpivotpro.com/2019/09/a-brief-treatment-of-divide-rankx-and-n-a/. The author is Rob Collie

Read More

Read More

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

Read More

Read More

In my last post I showed lots of examples of how Power BI’s new custom format string feature can be used to format numbers. This post, looking at dates and times, will be a bit different for two reasons: there are a lot more useful examples of custom date and time formats built into Power […]

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

Read More

Read More

Under time pressure today… So I’ll just leave these here.  Yes, these images are all Power BI.  They are all clickable links to interactive pages. Rather than my usual wall of text… How about we just open this up to… This post first appeared at https://powerpivotpro.com/2019/09/yes-power-bi-can-do-this-free-interactive-nfl-stats/. The author is Rob CollieRead More

This post first appeared at https://powerpivotpro.com/2019/09/yes-power-bi-can-do-this-free-interactive-nfl-stats/. The author is Rob Collie

Read More

Read More

Here’s a quick recap of all the features and announcements in the monthly of August. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-service-and-mobile-august-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-august-2019-feature-summary/. The author is 

Read More

Read More

We have plenty of resources to get ready for the upcoming release wave with confidence. Learn more about the upcoming Power BI features included in 2019 release wave 2 with our new overview video and guide, and understand key milestones in this process. This post first appeared at https://powerbi.microsoft.com/en-us/blog/learn-more-about-the-new-innovations-in-power-bi-starting-october-2019/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/learn-more-about-the-new-innovations-in-power-bi-starting-october-2019/. The author is 

Read More

Read More

We are excited to announce new improvements to Power BI dataflows releasing this month including non-admin gateway support and further improvements to the enhanced compute engine. We also have released a new best practices guide for dataflows to help you make the best use of the new enhanced compute engine. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-september-2019-feature-summary/. […]

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

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-august-2019-update/. The author is Read More

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

Read More

Read More

In this article I am going to share with you a concept to manage refresh failures in production PowerBI.com reports. In a perfect world, you should configure your queries so that they “prevent” possible refresh … Preventing & Managing Refresh Failures in Power BI Read More This post first appeared at https://exceleratorbi.com.au/preventing-managing-refresh-failures-in-power-bi/. The author is Matt AllingtonRead […]

This post first appeared at https://exceleratorbi.com.au/preventing-managing-refresh-failures-in-power-bi/. The author is Matt Allington

Read More

Read More

Now that we can apply custom format strings to fields and measures in Power BI in the September 2019 release, I thought it would be useful to provide some examples of what’s possible with this very flexible new feature because the existing documentation for VBA isn’t easy to make sense of. In fact there’s so […]

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

Read More

Read More

Follow @gilra Since the release of Power BI Template Apps, more than 50 new apps have joined the marketplace. It’s about time we would be able to search for template apps in a new way – in our own Power BI report that can be installed as a Template App – and not just by […]

This post first appeared at https://datachant.com/2019/09/11/power-bi-template-apps-exploration-tool/. The author is Gil Raviv

Read More

Read More

You’ll notice one of our exciting updates right away when creating new reports with the September update of Power BI Desktop, a new, modern default theme! Not only do we have a new default theme, but we’ve more than doubled the number of built-in theme options for your report. If you’re a theme author, potentially […]

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

Read More

Read More

We’re excited about all the new innovations we’re rolling out in the October 2019 Microsoft business applications release and want to share the highlights with you. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-microsoft-business-applications-october-virtual-launch-event/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-microsoft-business-applications-october-virtual-launch-event/. The author is 

Read More

Read More

In Shabnam Watson’s recent blog post on a bug she found when trying to create a Live connection from Power BI to Analysis Services she mentioned that the AutoSetDefaultInitialCatalog server property could be used to solve her problem. This piqued my interested because I’d seen this property but had no idea what it did exactly […]

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

Read More

Read More

Yesterday night Power BI Facebook connector started to return errors when used to import public facebook pages. If you are using my Facebook Pages – Basic Analysis template app from AppSource, or have any of my Power BI facebook reports, you will have this error when refreshing your report: DataSource.Error: Facebook: (#10) To use ‘Page […]

This post first appeared at https://datachant.com/2019/09/05/a-new-facebook-connector-error/. The author is Gil Raviv

Read More

Read More

Nothing Cures the Old Writer’s Block Quite Like Advanced NFL Stats and Power BI (Artist’s Rendition – But the Real Thing is Soon to Be Revealed) Yeah yeah yeah… So it’s been awhile since we’ve posted an article around here. … This post first appeared at https://powerpivotpro.com/2019/09/coming-soon-no-checkdowns-aka-nfl-season-is-dashboard-season/. The author is Rob CollieRead More

This post first appeared at https://powerpivotpro.com/2019/09/coming-soon-no-checkdowns-aka-nfl-season-is-dashboard-season/. The author is Rob Collie

Read More

Read More

It may so happen that you need to change the names of all the columns in a table in Power BI. It is of course possible to change each column name by editing it manually. … Renaming all the Columns in a Table at Once using ‘M’ Language and Power Query Read More This post […]

This post first appeared at https://exceleratorbi.com.au/renaming-all-the-columns-in-a-table-at-once-using-m-language-and-power-query/. The author is Ramana

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