In The Trenches
With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS
We are back to finish our discussion on the visualizations for Comparing Rows in Power Query! How to visualize the prices and daily changes The two metals have very different price ranges so it is difficult to see them in… This post first appeared at https://powerpivotpro.com/2018/10/comparing-rows-in-power-query-part-2/. The author is Dany HoterRead More
This month’s update for Power BI Desktop filled with both small and large improvements across the entire product. One huge update is support in the Power BI service for both our composite model and aggregation previews. This really enables you to start using these preview features end-to-end for your normal reports. We also have two […]
It is very difficult for an organisation to decide whether to buy Power BI Premium or to stick with Power BI Pro. Power BI Premium represents a big financial commitment, but how do you know whether the benefits will be worth the costs involved? This was a question that Melissa Coates and I dealt with […]
If you happen to be in Las Vegas November 8th make sure and visit Charles Sterling for his session at the Microsoft Company Store: An all demo view of Microsoft’s new Power platform This post first appeared at https://powerbi.microsoft.com/en-us/blog/see-the-power-platform-in-action-at-the-las-vegas-company-store-nov-8th/. The author is Read More
Power BI MVP and crowd Favorite Avi Singh will be presenting: Building Impactful Financial Dashboards Using Microsoft Power BI Webinar 10/16 This post first appeared at https://powerbi.microsoft.com/en-us/blog/webinar-10-16-build-impactful-financial-dashboards-using-microsoft-power-bi-with-avi-singh/. The author is Read More
Data Warehouses: What Do I Know? Well, I’m no expert. I learned Power Pivot and Power BI through Excel. What I know is from helping to build a SQL data warehouse. That is, I’ve worked with a data warehouse pro.… This post first appeared at https://powerpivotpro.com/2018/10/so-youre-getting-a-data-warehouse-for-power-bi/. The author is Fred KaffenbergerRead More
Custom visuals bring great value to your organization. By using tailor-made visuals, enterprises can tell their own story and visualize data in the best way! In some organizations custom visuals are even more important – they might be necessary to convey specific data or insights unique to the organization, they may have special data requirements, […]
One thing I often get asked is “How do I create good looking Power BI Reports?”. This is a very good question and unfortunately the answer is not straight forward. I like to think of the visual appeal as the “Art” of communicating data insights. The other major consideration is “what and how” to communicate […]
Hello P3 Blog readers! Well, it’s been a while since I’ve blogged – what can I say, it was a busy summer! BOO you say?! You need your Cat Meme fix!?! Well, let’s see if I can DO something about… This post first appeared at https://powerpivotpro.com/2018/10/finding-the-right-data-using-sql-or-power-bi/. The author is Krissy DyessRead More
Starting today, POLITICO Europe is using Power BI as the data visualization technology powering its new Elections hub. Thanks to Power BI, readers can interact with the latest information about the expected results of the upcoming European Parliament elections. This post first appeared at https://powerbi.microsoft.com/en-us/blog/politico-europe-bets-on-microsoft-power-bi-to-report-on-the-european-union-elections/. The author is Read More
This is exciting! The digital version of the book “Collect, Combine and Transform Data Using Power Query in Excel and Power BI” is out. Follow @gilra This post first appeared at https://datachant.com/2018/10/09/the-digital-version-of-the-new-powerquery-book-is-ready/. The author is Gil RavivRead More
Calendar tables are an absolute requirement for time-intelligence calculations in Power BI. In this week’s webinar Power BI MVP Tristan Malherbe will deliver a webinar on how to build a proper calendar table using Power Query and M language. This post first appeared at https://powerbi.microsoft.com/en-us/blog/10-11-webinar-how-to-use-power-query-and-m-to-create-calendar-tables-with-tristan-malherbe/. The author is Read More
This blog post covers the latest updates for Power BI Developers community- Power BI Embedded and Custom Visuals. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-september-update-2018/. The author is Read More
The short answer: no. The long answer: This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/PfxBh3Kck54/. The author is Chris WebbRead More
We are proud to announce at the up coming Power BI World Tour we will be showing many of these features live in demos and break out sessions. If you are not familiar with the Power BI World Tour it is a seven city conference bringing attendees unprecedented access to premium Power BI content designed […]
This is going to sound obscure, and it is, but recently I’ve been using the #table() intrinsic function in M a lot – specifically the version that takes a table type as its first parameter (as I describe here) – and because it’s a bit of a pain to have to write the M code […]
It is straightforward to compare values between each row in an Excel table and the next row. You can create a calculated column in a table and reference values in other columns in the same row by name and cells… This post first appeared at https://powerpivotpro.com/2018/10/comparing-rows-in-power-query-part-1/. The author is Dany HoterRead More
Thank you for installing the app and sharing your valuable feedback. We have since been working to make improvements in the app and I am excited to share that we… This post first appeared at https://powerbi.microsoft.com/en-us/blog/query-metrics-available-in-power-bi-premium-capacity-metrics-app/. The author is Read More
The webinar will aim to reset your understanding of what is possible in DAX by walking through some interesting code highlights from a recent series of games built using DAX (Blackjack, Sudoku , Tic Tac Toe , Hangman & Minesweeper). This post first appeared at https://powerbi.microsoft.com/en-us/blog/webinar-10-2-creative-dax-solutions-by-philip-seamark/. The author is Read More
Many accountants consider that cash flow statements are the most important indicator of a company’s performance, as they do not involve estimates or judgments of the preparers. While indirect method cash flow statements can be prepared easily from P&L… This post first appeared at https://powerpivotpro.com/2018/09/power-pivot-cracks-direct-method-cashflow-conundrum/. The author is Sakiko StickleyRead More