In The Trenches
With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS
ArcGIS for Power BI is a custom data visualization tool built within Power BI that brings mapping capabilities to your reports and dashboards. ArcGIS for Power BI is now available on Power BI Report Server. This functionality will enable all Esri Enterprise users who use Report Server to seamlessly use ArcGIS for Power BI. This […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/whats-new-with-arcgis-for-power-bi/. The author isWelcome to the first feature summary of 2021! This month, we have a couple of updates on ongoing previews, as well as a new color picker that features RGB color selector and a search bar to make discovery of features easier. Additionally, we are introducing new filter operations and enable subscriptions for reports and dashboards […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-february-2021-feature-summary/. The author isThis blog post covers the latest updates for the Power BI Developer community. Don’t forget to check out our last developer blog post if you haven’t done so already. Here is the list of updates: Embedded analytics updates Announcements Power BI Embedded Generation 2 (preview) Power BI embedded analytics new Contoso demo New Client APIs […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-february-2021-update/. The author isHere’s something that will Blow Your Mind if you’re a Power Query/M fan. Did you know that there’s a way you can get query folding to work if you’re using a native SQL query on SQL Server or Postgres as your data source? There’s a new option on the Value.NativeQuery() M function that allows you […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/Ku3_wTeoosI/. The author is Chris WebbPower BI Premium has supported metadata translations – translations for table, column and measure names etc – for a while now. Kasper has a great blog showing how to use this feature here; Tabular Editor makes it very easy to edit metadata translations too. However (unlike SSAS Multidimensional) Power BI doesn’t have native support for […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/4ygYh8_kRT8/. The author is Chris WebbToday we’re announcing that for the 14th consecutive year1 Microsoft has been positioned as a Leader in the 2021 Gartner Magic Quadrant for Analytics and Business Intelligence Platforms. For the third year, Microsoft is positioned furthest to the right for completeness of vision and furthest up in the ability to execute within the Leaders’ quadrant. This […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/microsoft-named-a-leader-in-2021-gartner-magic-quadrant-for-analytics-and-bi-platforms/. The author isThe past year has confirmed that a digital-first strategy is not just a trend, but the new standard for business moving forward. What business calls “digital life” is just life for most people, as is the expectation that organizations will keep up with the accelerating volume of data and pace of change while protecting sensitive […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/data-insights-without-limit-security-without-compromise/. The author isToday, we are announcing General Availability (GA), along with several enhancements. This post first appeared at https://powerbi.microsoft.com/en-us/blog/net-core-support-for-analysis-services-client-libraries-is-ga/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/net-core-support-for-analysis-services-client-libraries-is-ga/. The author isLast year Marco Russo wrote a very useful blog post pointing out the performance problems you can run into when connecting to data stored in ADLSgen2 from Power BI when there are a large number of files elsewhere in the container. You can read that post here: https://www.sqlbi.com/blog/marco/2020/05/29/optimizing-access-to-azure-data-lake-storage-adls-gen-2-in-power-query/ This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/89WN0Q9tx9g/. The author […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/89WN0Q9tx9g/. The author is Chris WebbThis course covers key aspects of Power BI administration, including creating a Power BI tenant, managing access and permissions, resources and capacity, Premium capacity administration, broadening the reach – embedded, working with Data Gateway and best practices for successful Power BI administration. Each of the 10 modules will be delivered and monitored for questions by […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-power-bi-instructor-led-training-24th-25th-of-february-2021-from-500-am-900-am-pst/. The author isLearn how to develop cutting-edge web applications using .NET 5, Azure AD and the App-Owns-Data embedding model in Power BI. Campers will get increasingly excited as the learn how to implement App-Owns-Data embedding in a custom .NET 5 web application which involves first calling the Power BI Service API and then afterwards calling the Power […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-power-bi-dev-camp-thursday-25-february-2021-developing-with-net-5-and-app-owns-data-embedding/. The author isWe are thrilled to announce that the second generation of Power BI Embedded, referred to as Embedded Gen 2, is available for its Azure subscribers to use during the preview period. All of the Power BI Embedded Gen 1 capabilities such as pausing and resuming the capacity, are preserved in Gen 2 and the price […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-embedded-generation-2-preview/. The author isFollowing on from my last two posts comparing the performance of importing data from ADLSgen2 into Power BI using the ADLSgen2 connector and going via Synapse Serverless (see here and here), in this post I’m going to look at a third option for connecting to CSV files stored in ADLSgen2: connecting via a Common Data […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/Sgt-BecvkCk/. The author is Chris WebbWant to improve the performance and design of your Power BI model? Run these newly published rules against your model to quickly identify areas of improvement! This post first appeared at https://powerbi.microsoft.com/en-us/blog/best-practice-rules-to-improve-your-models-performance/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/best-practice-rules-to-improve-your-models-performance/. The author isIn my last post I showed how importing all the data from a folder of csv files stored in ADLSgen2 without doing any transformations performed about the same whether you use Power Query’s native ADLSgen2 connector or use Azure Synapse Serverless. After publishing that post, several people made the same point: there is likely to […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/66TF7d83ZmQ/. The author is Chris WebbWelcome to our very first update of 2021! We have several exciting updates rolling out this month for paginated reports, including an improved editing and publishing experience in Power BI Report Builder, additional sample reports, Microsoft Dataverse connectivity and much more! Read on to learn more about all of these exciting new developments. This post first appeared at https://powerbi.microsoft.com/en-us/blog/paginated-report-january-2021-feature-summary/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/paginated-report-january-2021-feature-summary/. The author isWe are kicking off 2021 by sharing an updated version of Power BI Report Server! With this update, we’re bringing visual zoom sliders, custom publish message and ESRI ArcGIS support, amongst others. Read on to get the full details. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-january-2021-feature-summary/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-january-2021-feature-summary/. The author is4 years ago, I published on my blog a technique to mask data in Power BI. In today’s post, I wanted to re-share it and illustrate how effective it can for demo purposes – Let’s say you work with confidential data, and you would like to share your Power BI report with an external audience […]
This post first appeared at https://datachant.com/2021/01/28/masking-columns-in-power-bi/. The author is Gil RavivWe’re pleased to share that we are now previewing step folding indicators in Power Query Online. These indicators will allow you to understand which steps fold, and which steps don’t. Read on for more. This post first appeared at https://powerbi.microsoft.com/en-us/blog/step-folding-indicators-for-power-query-online/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/step-folding-indicators-for-power-query-online/. The author isWelcome Home: It’s not just a bombastic prog-metal song Continuous hiring mode In P3’s history, we’ve had a bit of a “reactive cyclical” hiring model. Demand for our services would grow, stretching us to the limits of staffing, so we’d add 1-2 new consultants. And those new consultants would instantly take us from “short of […]
This post first appeared at https://powerpivotpro.com/2021/01/p3-jobs-time-to-come-home/. The author is Rob Collie