Select Page

In The Trenches

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

I first blogged about this back in October 2021 when Microsoft announced live Power BI embedding was coming to PowerPoint. Believe it or not, the ability to embed Power Pivot reports into PowerPoint was one of the first features delivered by Microsoft way back in 2014 or 2015. It used […]Read More » This post […]

This post first appeared at https://exceleratorbi.com.au/power-bi-live-embedding-in-powerpoint/. The author is Matt Allington

Read More

Read More

In part 1 of this series I showed how you could create a very simple custom connector for Power Automate that allows you to call the Power BI Enhanced Refresh API. However, I didn’t show what I think is the main reason you’d want to build a custom connector: the ability to refresh specific tables […]

This post first appeared at https://blog.crossjoin.co.uk/2022/08/14/calling-the-power-bi-enhanced-refresh-api-from-power-automate-part-2-refreshing-specific-tables-and-partitions/. The author is Chris Webb

Read More

Read More

I’ve been pretty busy over the last few months. The demand for Power BI skills has never been stronger, and my company is super busy. I haven’t written a blog article for a while, but I wanted to take a bit of time out this morning to talk about the […]Read More » This post […]

This post first appeared at https://exceleratorbi.com.au/power-bi-desktop-august-2022-release-features-i-love/. The author is Matt Allington

Read More

Read More

I love the new Power BI Enhanced Refresh API: it allows you to do things like refresh individual tables in your dataset, override incremental refresh policies, control the amount of parallelism, cancel refreshes and a lot more, while being easier to use than the XMLA Endpoint. However, like the XMLA Endpoint, one problem remains: how […]

This post first appeared at https://blog.crossjoin.co.uk/2022/08/07/calling-the-power-bi-enhanced-refresh-api-from-power-automate-part-1-creating-a-basic-custom-connector/. The author is Chris Webb

Read More

Read More

The Power BI app for Microsoft Teams is coming to Teams mobile. This helps users stay up to date and never miss activity in their Power BI reports and scorecards. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-power-bi-app-is-available-in-microsoft-teams-mobile/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-power-bi-app-is-available-in-microsoft-teams-mobile/. The author is 

Read More

Read More

Recently, the P3 Adaptive Power Apps team spent some time participating in thought sessions around the topic of the symbiotic relationship between Power Apps and Power BI. Specifically, the team discussed when one platform should be the primary host as there are integration options that work in both directions. After working through the options with […]

This post first appeared at https://p3adaptive.com/2022/08/power-apps-and-power-bi-better-together/. The author is Kristi Cantor

Read More

Read More

The Case: The new Field Parameters feature from Microsoft had been added to a report page and worked appropriately for several weeks. When the report was opened on Tuesday, Field Parameters had disappeared and had been replaced by one of the original measures that had been feeding it. The complainant explained there was an unsuccessful […]

This post first appeared at https://p3adaptive.com/2022/08/the-case-of-the-disappearing-field-parameters-solved/. The author is Kristi Cantor

Read More

Read More

Azure Data Lake Storage Gen 2 and Azure Blobs connectors now support SAS Key connectivity! This post first appeared at https://powerbi.microsoft.com/en-us/blog/adls-gen2-and-azure-blobs-sas-key-connectivity/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/adls-gen2-and-azure-blobs-sas-key-connectivity/. The author is 

Read More

Read More

Join the public preview to enable additional settings for workspaces in Power BI This post first appeared at https://powerbi.microsoft.com/en-us/blog/analysis-services-server-properties-in-power-bi-premium-are-now-in-public-preview/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/analysis-services-server-properties-in-power-bi-premium-are-now-in-public-preview/. The author is 

Read More

Read More

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

Read More

Read More

One feature of Power BI incremental refresh I’ve always been meaning to test out is the ability to create your own M queries to work with the “detect data changes” feature, and last week I finally had the chance to do it. The documentation is reasonably detailed but I thought it would be a good […]

This post first appeared at https://blog.crossjoin.co.uk/2022/07/31/custom-queries-for-detect-data-changes-in-power-bi-incremental-refresh/. The author is Chris Webb

Read More

Read More

Our Ideas site has been the main place for you to leave suggestions. the past year we have made improvements to the ideas site to keep the site secure, spam free and allow users to submit ideas through the Ideas portal. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-ideas-site-improvement-updates/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-ideas-site-improvement-updates/. The author is 

Read More

Read More

I like free stuff and I like books, so of course I like free books – and it seems that the more I provide free publicity for relevant books here the more free books I get sent. I’ve now got enough to merit writing another post covering those I’ve received recently from various publishers and […]

This post first appeared at https://blog.crossjoin.co.uk/2022/07/24/yet-another-power-bi-and-synapse-book-roundup/. The author is Chris Webb

Read More

Read More

Last week, at Inspire, we announced a key enhancement to AppSource visuals; You can now purchase and manage licenses of licensed visuals through Microsoft AppSource! This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-a-new-way-to-purchase-licensed-power-bi-visuals-and-manage-licenses-through-microsoft-platforms/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-a-new-way-to-purchase-licensed-power-bi-visuals-and-manage-licenses-through-microsoft-platforms/. The author is 

Read More

Read More

In the current economic climate businesses are being asked to leverage data to make critical business decisions in an even faster, more efficient, precise, and effective manner than ever before. Is that even possible? How can you move beyond outdated processes with your current resources? The answer: Power BI Power BI is more than just […]

This post first appeared at https://p3adaptive.com/2022/07/upcoming-dashboard-in-a-day-course/. The author is Kristi Cantor

Read More

Read More

Partners have been listing Power BI visuals on AppSource for years, but now we’re excited to introduce e-commerce through our popular commercial marketplace. In order to ease sales, boost revenue, and optimize operations for partners, and to improve the experience for Power BI users! This post first appeared at https://powerbi.microsoft.com/en-us/blog/partners-introducing-a-new-way-to-manage-enforce-and-transact-licenses-for-power-bi-visuals/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/partners-introducing-a-new-way-to-manage-enforce-and-transact-licenses-for-power-bi-visuals/. The author is 

Read More

Read More

Metrics visual is now available. This post first appeared at https://powerbi.microsoft.com/en-us/blog/metric-visual-is-now-available-in-preview/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/metric-visual-is-now-available-in-preview/. The author is 

Read More

Read More

Power BI APIs can support you at any scale, but there is no one-size-fits-all API. The ExecuteQueries API is a great choice at small scale. For large-scale solutions, switch to XMLA endpoints and host your datasets on Power BI Premium. This post first appeared at https://powerbi.microsoft.com/en-us/blog/executequeries-rest-api-versus-xmla-endpoints-at-scale/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/executequeries-rest-api-versus-xmla-endpoints-at-scale/. The author is 

Read More

Read More

We’re very excited to announce that the Power BI integration in Dynamics 365 and model driven Power Apps, which shipped as a preview last December, is now generally available. Dynamics 365 and model driven Power Apps give organizations the ability to quickly build essential line-of-business apps in a low-code environment, increasing agility and modernizing processes. […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/visualizing-views-in-dynamics-365-generally-available/. The author is 

Read More

Read More

Recently I collaborated with a number of people from Microsoft and Snowflake to write a blog post on best practices for using Power BI in DirectQuery mode on Snowflake. You can read it here: https://medium.com/@jerellegainey/best-practices-for-using-power-bi-in-directquery-mode-with-snowflake-bfd1312ca7ab This post first appeared at https://blog.crossjoin.co.uk/2022/07/17/power-bi-directquery-best-practices-for-snowflake-and-other-databases/. The author is Chris WebbRead More

This post first appeared at https://blog.crossjoin.co.uk/2022/07/17/power-bi-directquery-best-practices-for-snowflake-and-other-databases/. The author is Chris Webb

Read More

Read More

Hansen BI brings you the latest insights from the most popular Microsoft Business Intelligence bloggers around the world

Blogroll