In The Trenches
With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS
Power Query Online is, as the name suggests, the online version of Power Query – it’s what you use when you’re developing Power BI Dataflows for example. Sometimes when you’re building a complex, slow query in the Query Editor you’ll notice a message in the status bar at the bottom of the page telling you […]
This post first appeared at https://blog.crossjoin.co.uk/2022/06/26/monitoring-power-query-online-memory-and-cpu-usage/. The author is Chris WebbPreview data is now available! This post first appeared at https://powerbi.microsoft.com/en-us/blog/preview-data-is-now-available-in-the-dataset-details-page/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/preview-data-is-now-available-in-the-dataset-details-page/. The author isThe most exciting (at least for me) feature in the new Enhanced Refresh API (blog announcement | docs) is the ability to cancel a dataset refresh that’s currently in progress. Up until now, as this blog post by my colleague Michael Kovalsky shows, this has been quite difficult to do: not only do you need […]
This post first appeared at https://blog.crossjoin.co.uk/2022/06/19/cancelling-power-bi-dataset-refreshes-with-the-enhanced-refresh-api/. The author is Chris WebbAs technology continues to integrate with all aspects of our lives, it is increasingly obvious that business apps are becoming more and more important to how a business function. For decades, companies knew that many routine actions were consuming a disproportionally large part of their time and that automation would be the key to increasing […]
This post first appeared at https://p3adaptive.com/2022/06/top-10-reasons-to-use-power-apps/. The author is Kristi CantorWelcome to the June 2022 update. We are excited to announce the general availability of the new Format Pane, error bars and information protection updates, table navigation improvements, Connect to datamarts and Power BI Data Storytelling features. There is more to explore, please continue to read on. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-june-2022-feature-summary/. The author is Read […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-june-2022-feature-summary/. The author isThere are several updates coming to email subscriptions that use full report attachments that we want to make you aware of, including extending the maximum length of reports to 50 pages, appearance in the Gen2 metrics app, and deprecation in the original version of Power BI Premium. This post first appeared at https://powerbi.microsoft.com/en-us/blog/updates-to-full-report-attachments-for-email-subscriptions-in-premium-gen2/. The author is Read […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/updates-to-full-report-attachments-for-email-subscriptions-in-premium-gen2/. The author isIf you’re working with DirectQuery in Power BI then one of the most important properties you can set on your dataset is the “Maximum connections per data source” property. You can find it on the Published Dataset Settings tab in the Options dialog in Power BI Desktop: The description of what it does in the […]
This post first appeared at https://blog.crossjoin.co.uk/2022/06/12/how-the-maximum-connections-per-data-source-property-on-power-bi-directquery-datasets-can-affect-report-performance/. The author is Chris WebbMay Release SQL Server Reporting Services This post first appeared at https://powerbi.microsoft.com/en-us/blog/reminder-of-features-being-removed-with-the-next-release-of-sql-server/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/reminder-of-features-being-removed-with-the-next-release-of-sql-server/. The author isIn amongst all the announcements at Build recently, you may have heard about a new member of the Power Platform being launched: Power Pages. You can read the docs here, and there’s a good, detailed video overview here, but here’s a quick summary of what it is: Microsoft Power Pages is a secure, enterprise-grade, low-code […]
This post first appeared at https://blog.crossjoin.co.uk/2022/06/05/build-web-sites-and-embed-power-bi-reports-in-them-using-power-pages/. The author is Chris WebbGeneral availability announcement for Enhanced Refresh with the Power BI REST API. Perform fine-grain refresh operations for improved scalability. This post first appeared at https://powerbi.microsoft.com/en-us/blog/enhanced-refresh-with-the-power-bi-rest-api-is-now-generally-available/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/enhanced-refresh-with-the-power-bi-rest-api-is-now-generally-available/. The author isThere’s an old joke about “Export to Excel” being the most important feature of any BI tool. In fact, I’d say export to Excel is one of the most important features of any enterprise application of any type. Of course the reason we joke about it is that we know it’s a Bad Thing and […]
This post first appeared at https://blog.crossjoin.co.uk/2022/05/29/add-export-to-excel-with-power-query-to-your-application/. The author is Chris WebbOn-premises data gateway May 2022 update is now available This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-may-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-may-2022-update-is-now-available/. The author isAs part of our GA work for the ExecuteQueries REST API, we delivered a new Power Automate action to run queries against Power BI datasets. This action delivers a straightforward low-code/no-code experience to BI users who want to streamline repetitive, mundane tasks and processes. The purpose of this blog post is to help you get […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/unlocking-new-self-service-bi-scenarios-with-executequeries-support-in-power-automate/. The author isWe’re excited to bring you a new version of Power BI Report Server this Spring! With the May 2022 update, we have a variety of new enhancements, including Dynamic format strings support, multi row card selection, canvas zoom, updated slicer defaults and many more. Please continue to read on! This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-may-2022-feature-summary/. The […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-may-2022-feature-summary/. The author isWe are happy to announce that the ExecuteQueries REST API is now GA. By using this REST API, you can query datasets in Power BI from practically any modern environment on any platform, as long as you can authenticate with Azure Active Directory (AAD) and construct a Web request. The query functionality is comparable to […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-of-the-executequeries-rest-api/. The author isMay 2022’s release of Power BI Desktop is the best releases we’ve seen in several years. They released a new gem of a featured called FIELD PARAMETERS and this blog is going to go over the benefits to you as a developer While there are a ton of blogs and videos already out there covering how incredible […]
This post first appeared at https://p3adaptive.com/2022/05/completing-the-set-up-field-parameters-using-tabular-editor/. The author is Mark BeedleToday, we are excited to announce General Availability (GA) of automatic aggregations, along with several important improvements. By using automatic aggregations in Power BI Premium, you can unlock cloud-scale data volumes for interactive analysis. Automatic aggregations import data into the dataset only at the aggregated level while leaving the detail data at the source to […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-of-automatic-aggregations/. The author isSQL Server 2022 Analysis Services will support composite models and it is now ready for you to try out with the CTP2 that has just launched. After you install this CTP for SQL Server 2022 on a server, tabular models are hosted on that server can now be used to create a composite model with. […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/composite-models-on-sql-server-analysis-services/. The author isMicrosoft Build represents the ultimate developer event. A hundred thousand developers from across the world gather for three days with their peers to learn, engage, and collaborate on the latest innovations and tools from Microsoft. This post first appeared at https://powerbi.microsoft.com/en-us/blog/democratize-enterprise-analytics-with-microsoft-power-bi/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/democratize-enterprise-analytics-with-microsoft-power-bi/. The author isAnnouncing public preview of datamart in Power BI, a new Power BI Premium self-service capability that enables users to uncover actionable insights through their own independent and dependent data sets. For the first time ever, we are empowering everyone with the right-sized ability to build datamarts that can be succinctly and centrally governed and managed […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-public-preview-of-datamart-in-power-bi/. The author is