Select Page

In The Trenches

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

Still Waters Run Deep Yeah, we haven’t had a post here since October.  But that doesn’t mean things haven’t been going on! We started as a blog – in 2009! – and I suspect that many longtime followers still think… This post first appeared at https://powerpivotpro.com/2020/01/big-changes-coming-in-q1-2020-including-new-classes/. The author is Rob CollieRead More

This post first appeared at https://powerpivotpro.com/2020/01/big-changes-coming-in-q1-2020-including-new-classes/. The author is Rob Collie

Read More

Read More

Very occasionally you may find that a report that is slow to render – but still renders successfully – in Power BI Desktop shows the error “Visual has exceeded the available resources” for some visuals when published to the Power BI Service: Clicking on “See details” will show a dialog that looks something like this: […]

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

Read More

Read More

This is a new post of the Bad Practices in Power BI series – This time we discuss the momentum of Power BI and what you can do about it (or fail to). Follow @gilra This post first appeared at https://datachant.com/2020/01/17/are-you-riding-the-wave-of-power-bi/. The author is Gil RavivRead More

This post first appeared at https://datachant.com/2020/01/17/are-you-riding-the-wave-of-power-bi/. The author is Gil Raviv

Read More

Read More

Our business applications community is growing, so we needed a different venue, resulting in a new date and location for the Microsoft Business Applications Summit May 6–7, 2020 in Dallas, Texas. We hope to see you there! This post first appeared at https://powerbi.microsoft.com/en-us/blog/come-to-microsoft-business-applications-summit-this-may/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/come-to-microsoft-business-applications-summit-this-may/. The author is 

Read More

Read More

When you open the Power BI Premium metrics app you’re presented with the Capacity health center, which provides an overview of the health of your Power BI Premium capacity. This post first appeared at https://powerbi.microsoft.com/en-us/blog/premium-capacity-metrics-app-new-health-center-with-kpis-to-explore-relevant-metrics-and-steps-to-mitigate-issues/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/premium-capacity-metrics-app-new-health-center-with-kpis-to-explore-relevant-metrics-and-steps-to-mitigate-issues/. The author is 

Read More

Read More

When the new “Refresh a dataset” action for Power Automate (formerly Flow) was released last year I couldn’t help thinking there must be something really cool you could do with it – I just didn’t know what. There are lots of great resources explaining the basics (see Jon Levesque’s video here for example) and Adam […]

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

Read More

Read More

As most readers of my website would surely know, Microsoft Excel has had a dual axis line chart as a standard charting visual for many many (many) years.  A dual axis line chart is needed … Dual Axis Line Chart in Power BI Read More This post first appeared at https://exceleratorbi.com.au/dual-axis-line-chart-in-power-bi/. The author is Matt AllingtonRead More

This post first appeared at https://exceleratorbi.com.au/dual-axis-line-chart-in-power-bi/. The author is Matt Allington

Read More

Read More

Back in 2018 I wrote an article showing how to extract data from websites using Power Query in Excel. For simple websites this process is very straightforward. For more complex websites the process is not … Extracting Data from Complex Web Pages with Power BI Read More This post first appeared at https://exceleratorbi.com.au/extracting-data-from-complex-web-pages-with-power-query/. The author is Matt […]

This post first appeared at https://exceleratorbi.com.au/extracting-data-from-complex-web-pages-with-power-query/. The author is Matt Allington

Read More

Read More

Follow @gilra Back in May 2019, I introduced the Power BI Pixel technique to track usage on Power BI. In today’s post, I will share the detailed implementation steps to help you build your own Power BI Pixel and track users and the filter selections they make in your Power BI report. This post first […]

This post first appeared at https://datachant.com/2020/01/06/power-bi-pixel-a-new-way-to-track-usage-on-power-bi/. The author is Gil Raviv

Read More

Read More

Following on from the series of posts I wrote last month (starting here) about testing the performance of Power BI reports in the browser, I would now like to highlight one possible cause of slow report rendering performance: the over-use of custom visuals. Before we go any further, though, let me be absolutely clear about […]

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

Read More

Read More

Happy New Year! In honor of the new year, our team put together this fun video where we reveal what makes Power BI what it is today! Enjoy! This post first appeared at https://powerbi.microsoft.com/en-us/blog/happy-new-year-from-power-bi-desktop-3/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/happy-new-year-from-power-bi-desktop-3/. The author is 

Read More

Read More

Every year, on the anniversary of the first-ever post on this blog, I write a post summarising my thoughts on what’s happening in the world of Microsoft BI and what I’m up to professionally. This year has seen bigger changes than most: in June I closed down my company, gave up being self-employed after thirteen […]

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

Read More

Read More

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

Read More

Read More

One new feature that was introduced in the December 2019 release of Power BI Desktop, but which wasn’t mentioned in the release blog post, is the “Diagnose Step” button on the Tools tab of the Power Query Editor ribbon: As you might have guessed, it’s closely related to the Query Diagnostics functionality that was introduced […]

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

Read More

Read More

This is an end of year followup for the last article of the Series Bad Practices In Power BI. Follow @gilra This post first appeared at https://datachant.com/2019/12/21/power-bi-is-a-data-visualization-tool-2/. The author is Gil RavivRead More

This post first appeared at https://datachant.com/2019/12/21/power-bi-is-a-data-visualization-tool-2/. The author is Gil Raviv

Read More

Read More

We are excited to announce the availability of a new Power BI API called the activity log, which enables Power BI service admins to track user and admin activities within a Power BI tenant. This post first appeared at https://powerbi.microsoft.com/en-us/blog/the-power-bi-activity-log-makes-it-easy-to-download-activity-data-for-custom-usage-reporting/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/the-power-bi-activity-log-makes-it-easy-to-download-activity-data-for-custom-usage-reporting/. The author is 

Read More

Read More

Announcing the deprecation of TLS 1.1 and 1.0 in allignment with O365 announcemetn here: https://docs.microsoft.com/en-us/office365/troubleshoot/security/prepare-tls-1.2-in-office-365 This post first appeared at https://powerbi.microsoft.com/en-us/blog/deprecating-tls-1-0-and-1-1-support-in-power-bi/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/deprecating-tls-1-0-and-1-1-support-in-power-bi/. The author is 

Read More

Read More

In the coming weeks we will roll out a change to our default settings that requires Power BI admins to allow public embedding before end users can create new embed codes using Publish to web. The change will not affect existing embed codes, which will keep working as they have been. Read this blog to […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/heads-up-the-publish-to-web-default-is-changing-and-it-affects-who-can-create-public-embed-codes/. The author is 

Read More

Read More

Today, the new look for Power BI Mobile is generally available (GA) and becomes the default look for all users. You no longer need to turn the new look on in the app settings (and, you also can’t turn it off). So, now when you open Power BI mobile app, you’ll land on the new […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-mobile-new-look-is-now-ga-and-includes-your-activity-feed/. The author is 

Read More

Read More

We’re excited to introduce a new Power BI sample report for you to play around with. This report includes new features, shows designs factors you should take into consideration when building a report, and has been optimized Power BI Desktop, service, and mobile. You can see how visuals from AppSource can be added to your […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/take_a_tour_of_the_new_sales_returns_sample_report/. 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