In The Trenches
With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS
What is Multivariate Reporting and when is it helpful? Multivariate Reporting (also known as Small Multiples) uses a series of visuals with the same measure and same scales but showcases various partitions of the data. The benefit is that you can allow your report consumers to easily compare the same measure across dimensions and all […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/how-to-do-multivariate-reporting-with-power-bi/. The author isJoin the Power BI Embedded team at the Power Platform Summit Europe for a 2-hour session. During the session, we will cover the newest features and capabilities in Power BI Embedded such as: Control all visual menu actions programmatically – Options and Context Menus APIs has been extended to provide full control for each visual […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-embedded-session-at-power-platform-summit-europe-whats-new-in-power-bi-embedded/. The author isA few weeks ago at SQLBits I had a demo of a very interesting new tool for Power BI users called Power BI Sentinel. The website, with all the details, is here: Home This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/63Dqo0OGfwY/. The author is Chris WebbRead More
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/63Dqo0OGfwY/. The author is Chris WebbWe launched the public preview of new workspace experiences in August 2018 to enable Power BI workspace admins to use security groups to manage access to workspaces, enable BI teams to create workspaces without needing to create an Office 365 Group, and to provide granular workspace roles to make giving access to workspaces easier. At […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/update-on-the-new-workspace-experiences-preview-including-ga-timeline/. The author isFebruary was yet another exciting and busy month for Power BI, as we rolled out many features that were highly requested by our customers and community. Here’s a recap of all the announcements: Updates to the Premium Capacity Metrics app Export to PDF and filtered export for Power BI reports On-demand email subscriptions Bulk operations […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-service-and-mobile-february-2019-feature-summary/. The author isToday we presented at the 5th annual Gartner BI Bake Off session at the Gartner Data and Analytics Summit in Orlando, Florida and we are very excited to share the report with everyone. The topic this year is loneliness data from the Kaiser Family Foundation and The Economist Same as last year, a little bit of background: […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/bi-bake-off-at-gartner-data-and-analytics-summit-2019/. The author isFollowing on from my last post on attaching manually-created Common Data Model folders in Power BI dataflows, I was asked whether defining relationships between entities in the model.json file of the CDM folder results in relationships being created between tables in a Power BI dataset. I’ve just tested it, and I can confirm it does. […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/4SNM1gbFWFY/. The author is Chris WebbWe are happy to announce that we have just released the March update for the On-premises data gateway (version 3000.2.47) This month’s Gateway update includes an updated version of the Mashup Engine, which matches the one released as part of the Power BI Desktop March update. This will ensure that the reports that you publish […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-march-2019-update-is-now-available/. The author isNext week, 4,000+ data and analytics leaders will gather in Orlando, Florida for the 2019 Gartner Data and Analytics Summit. Microsoft is very excited to sponsor this event and bring some of our best experts to meet with attendees to discuss how to drive data and analytics into the core of your business. We will […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/microsoft-at-gartner-data-and-analytics-summit-2019-in-orlando-fl/. The author isOne of the things I like about my live, online training courses is that I get to hear great questions from the trenches from people learning DAX and Power BI. Last week, John asked me how to apply conditional formatting with a Text field (not a numeric field). I knew it could be done, but […]
This post first appeared at https://exceleratorbi.com.au/conditional-formatting-with-a-text-field-in-power-bi/. The author is Matt AllingtonWe’re looking for business professionals who use Microsoft Power BI and/or manage Power BI accounts to join our research panel. This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-our-research-panel/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-our-research-panel/. The author isMost of the focus on Power BI dataflows so far has been on the use of Power Query Online to load data from external data sources. However, when you create a dataflow you also have the option to attach an existing Common Data Model (CDM) folder stored in Azure Data Lake Storage Gen2: The documentation […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/ZMM1NiaQjTE/. The author is Chris WebbHello P3 Nation! After having the privilege of working with so many of you to share your journeys and techniques I was inspired to share my own. This is a bit of an intimidating group, and I struggled a bit… This post first appeared at https://powerpivotpro.com/2019/03/a-dax-tale-not-every-path-is-straight-and-narrow/. The author is Jason BaldessariRead More
This post first appeared at https://powerpivotpro.com/2019/03/a-dax-tale-not-every-path-is-straight-and-narrow/. The author is Jason BaldessariThis month we have a lot of exciting announcements. Two of our most requested features on UserVoice are releasing this month, heat maps and single select slicers. Additionally, we are making our complete facelift of the modeling view generally available. New DAX functions and improvements to existing features, such as buttons and the selection pane, […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-2019-feature-summary/. The author isI was trying to clean up my hard disk drive on my PC the other day. I use a program called WinDirStat to show me graphically what is taking space (as an aside, this is great software and you can download it here). After running the software I noticed that I had stored photos from […]
This post first appeared at https://exceleratorbi.com.au/find-and-delete-duplicate-photos-with-power-query/. The author is Matt AllingtonI generally try to avoid writing book reviews here, but the fact that there are so few books available on Power Query and M means that I’m making an exception for “Collect, Combine and Transform Data using Power Query in Excel and Power BI” by Gil Raviv. The first thing to say about this book […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/FA2Ml4pa-3U/. The author is Chris WebbWith sophisticated models and scalable compute, Artificial Intelligence becomes a realistic tool for data analysts. Power BI helps you get insights from your data. Now, with access to a set of models from Azure Cognitive Services and your custom models in Azure ML, you can easily enrich those insights with AI. Cognitive services in Power BI gives you access […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/easy-access-to-ai-in-power-bi-preview/. The author isNow that Azure Data Lake Storage Gen2 is now based on Azure Storage as its foundation, we have a new level to incorporate into our planning process the file system itself. The file system contains the files and folders, and is equivalent to a container in Azure Blob Storage which contains blobs. In ADLS Gen1, […]
This post first appeared at http://feedproxy.google.com/~r/SqlChick-MelissaCoates/~3/JvSKVjL_t_0/planning-for-accounts-containers-and-file-systems-for-your-data-lake-in-azure-storage. The author is Melissa CoatesIn this live event Microsoft Power Platform MVP, Ted Pattison, will teach you how to leverage the new app-only authentication support currently in preview for Power BI embedding and the Power BI Service API. Ted will also discuss emerging best practices with Microsoft’s App-Owns-Data model and explain why you should migrate away from older application […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/webinar-using-app-only-authentication-with-power-bi-embedding/. The author isWe are all waiting that the March update of Power BI Desktop will be released soon here. But today’s blog post will not be about it. I seized the moment to grab your attention to my Power BI update. Will you attend the Microsoft Power Platform World Tour in Chicago? I am going to speak […]
This post first appeared at https://datachant.com/2019/03/10/my-power-bi-march-update/. The author is Gil Raviv