In The Trenches
With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS
I was doing some online shopping last week and saw a price slicer with a histogram to show the concentration of price points. I thought it was pretty cool, so decided to see if I could build this in Power BI. I came up with a solution that works, and in this article I show […]
This post first appeared at https://exceleratorbi.com.au/slicer-with-histogram-in-power-bi/. The author is Matt AllingtonThis blog talks about the recently enabled feature “Multiple data source definitions to the same data source” This post first appeared at https://powerbi.microsoft.com/en-us/blog/multiple-data-source-definitions-on-the-on-premises-data-gateway-for-the-same-data-source/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/multiple-data-source-definitions-on-the-on-premises-data-gateway-for-the-same-data-source/. The author isWhoa! I can’t believe it is summer and almost 4th of July! It’s been WAY too long since I’ve blogged – I’ve just been SUPER busy here at P3! But I can’t let my Pug Meme readers down It seems… This post first appeared at https://powerpivotpro.com/2019/07/power-query-fail/. The author is Krissy DyessRead More
This post first appeared at https://powerpivotpro.com/2019/07/power-query-fail/. The author is Krissy DyessWith Power BI aggregations, organizations can perform petabyte-scale analytics with instant response times, exploring and analyzing trillions of rows of data and interactively extracting insights on the fly. Aggregations can dramatically reduce the cost of unlocking large datasets for decision making. This post first appeared at https://powerbi.microsoft.com/en-us/blog/unlock-petabyte-scale-data-sets-in-power-bi-with-aggregations-upcoming-general-availability/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/unlock-petabyte-scale-data-sets-in-power-bi-with-aggregations-upcoming-general-availability/. The author isTo kick off July, we’ve dropped the latest update to Power BI Report Builder in the download center. It includes, for the first time, the ability to browse your Power BI workspaces and connect to your Power BI datasets, whether or not they are backed by premium capacity. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-support-for-non-premium-power-bi-datasets-in-power-bi-paginated-report-builder/. The author […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-support-for-non-premium-power-bi-datasets-in-power-bi-paginated-report-builder/. The author isA quick Q&A-related tip. If you create a report in Power BI Desktop and use a Power BI service live connection: …and then you put a Q&A button on the report, clicking on the button gives the following error message: This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/_2C3L71ph-k/. The author is Chris WebbRead More
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/_2C3L71ph-k/. The author is Chris WebbAs a Power BI service admin, do you frequently need to list all workspaces in your tenant, and all reports, dashboards, and datasets in those workspaces as well? If the answer is yes, you probably had to build your solution such that in a first call, all workspaces had to be retrieved by using the […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/avoiding-workspace-loops-by-expanding-navigation-properties-in-the-getgroupsasadmin-api/. The author isWe’re two weeks post-GA of Paginated Reports in Power BI, and we wanted let you know about several updates we’ve made since then This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-paginated-reports-june-2019-feature-update-summary/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-paginated-reports-june-2019-feature-update-summary/. The author isAn interesting – if obscure – fact I learned recently is that a small number of DAX functions such as Median() do not work on tables with more than 2 billion rows in Analysis Services Tabular, Azure AS and Power BI. It’s quite easy to reproduce in Power BI. The following M expression returns a […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/9GpbAvw7VoA/. The author is Chris WebbThere was a new feature released in the June 2019 version of Power BI Desktop that I really like and I think warrants some explanation and review. The new feature allows you to pre-filter a slicer so that it only contains a subset of values that would otherwise appear in that slicer. Filters on Non-Slicer […]
This post first appeared at https://exceleratorbi.com.au/filters-on-power-bi-slicers-wait-what/. The author is Matt Allingtondataflow templates This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-dataflow-templates-a-quick-and-efficient-way-to-build-your-sales-leaderboard-and-get-visibility-over-your-sales-pipeline/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-dataflow-templates-a-quick-and-efficient-way-to-build-your-sales-leaderboard-and-get-visibility-over-your-sales-pipeline/. The author isWhen I was a Sophomore in college, I got a job doing tape backups at a food ingredients company. The developers there maintained a stack of paginated reports for the managers in the corner offices. At the time, I thought it… This post first appeared at https://powerpivotpro.com/2019/06/from-english-major-to-data-analyst/. The author is Fred KaffenbergerRead More
This post first appeared at https://powerpivotpro.com/2019/06/from-english-major-to-data-analyst/. The author is Fred KaffenbergerWe’re excited to announce we’ve started to roll-out the Viewer role for the new workspace experience, perfect for users who need to view content within workspaces without the ability to modify it. Viewer role enforces RLS even for users browsing the workspace, its a replacement for ‘read-only’ classic workspaces. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-new-viewer-role-for-power-bi-workspaces/. The author […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-new-viewer-role-for-power-bi-workspaces/. The author isWe are excited to announce new improvements to Power BI dataflows releasing this month including an enhanced compute engine to drastically improve data refresh times and a new set of dataflow templates to help you easily connect to common data sources mapped against the common data model. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-june-2019-feature-summary/. The author is Read […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-june-2019-feature-summary/. The author isThe Microsoft Business Application Summit is behind us but that doesn’t mean there’s a lot of content we can share with the community. We recorded almost every session on site, and we made them available in our community. This post first appeared at https://powerbi.microsoft.com/en-us/blog/mbas-2019-on-demand-featured-sessions-power-bi-roadmap-and-vision/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/mbas-2019-on-demand-featured-sessions-power-bi-roadmap-and-vision/. The author isWhile writing my Microsoft Business Applications Summit session on Power Query-related reasons for Power BI dataset refresh failures (which you can watch online here for free, along with all the other sessions), I remembered something important that I have been meaning to blog about for a while. It’s an excellent article by Ehren von Lehe […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/qboojWJENak/. The author is Chris WebbThree Goals In today’s article, I’m aiming to achieve three overlapping goals: Provide an intro to the concept of Value Above Replacement (aka VAR) – if you’re unfamiliar with this concept, I think you will find it stimulating. I’m not… This post first appeared at https://powerpivotpro.com/2019/06/power-bi-brain-candy-value-above-replacement/. The author is Rob CollieRead More
This post first appeared at https://powerpivotpro.com/2019/06/power-bi-brain-candy-value-above-replacement/. The author is Rob CollieBring Your Own Key (BYOK) preview available This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-bring-your-own-key-byok-preview-for-power-bi-premium/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-bring-your-own-key-byok-preview-for-power-bi-premium/. The author isLevel: Intermediate There was an announcement made a few weeks ago by Microsoft that nearly slipped under my radar. I don’t always read the more technical announcements because I don’t have a highly technical background. Luckily I read this particular announcement as it contained a nugget of gold that is very useful for anyone with […]
This post first appeared at https://exceleratorbi.com.au/power-bi-apis-for-non-programmers/. The author is Matt AllingtonThis post is to make you aware that there are some serious downsides when you choose to create reports in the Power BI Service rather than Power BI Desktop. The Short Version of the StoryI always recommend to Power BI authors that report creation & editing should happen in Power BI Desktop and to just […]
This post first appeared at http://feedproxy.google.com/~r/SqlChick-MelissaCoates/~3/spVePJJ4GUc/why-you-should-create-reports-in-power-bi-desktop-instead-of-power-bi-service. The author is Melissa Coates