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 AllingtonIn 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 WebbI’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 AllingtonI 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 WebbThe 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 isRecently, 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 CantorThe 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 CantorAzure 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 isJoin 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 isOn-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 isOne 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 WebbOur 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 isI 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 WebbLast 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 isIn 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 CantorPartners 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 isMetrics 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 isPower 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 isWe’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 isRecently 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