Select Page

In The Trenches

With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS

If you missed my webinar today, here it is: Follow @gilra This post first appeared at https://datachant.com/2018/02/22/powerbi_jedi_starwars/. The author is Gil RavivRead More

Read More

Welcome to the latest PowerPivotPro Coffee Talk, where members of the community discuss various topics related to Power BI, Power Pivot, and Analytics/BI in general. These conversations take place during the week on a Slack channel and are then lightly… This post first appeared at https://powerpivotpro.com/2018/02/coffee-talk-powerpivot-utilities/. The author is Reid HavensRead More

Read More

The scenario – source data sheets that are structured differently! Does Power Query sometimes seem too rigid? It’s great for defining a sequence of transformations to clean your data but requires the incoming data to be in a consistent format.… This post first appeared at https://powerpivotpro.com/2018/02/power-query-magic-dynamically-remove-leading-rows-columns/. The author is Narayana WindenbergerRead More

Read More

Last week a new, free tool for analysing the performance of MDX queries on SSAS Multidimensional was released: Analysis Services Query Analyzer. You can get all the details and download it here: https://ssasqueryanalyzer.github.io/ This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/unc51sV0kcI/. The author is Chris WebbRead More

Read More

Announcing Visual Studio Team Services (VSTS) Solution Template Blue Margin, Inc., Microsoft Gold Partner in Data Analytics and Data Platform just released a VSTS solution template to provide project… This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-visual-studio-team-services-vsts-solution-template/. The author is Read More

Read More

In early March, more than 3,000 data and analytics leaders will gather in Grapevine, Texas for the 2018 Gartner Data and Analytics Summit. Microsoft is excited to sponsor this event and bring some of our best thought leaders and experts to meet with you to discuss how to drive data and analytics into the core […]

Read More

Announcing the winner of the 2017 Power BI “Year in Review” data storytelling contest. With 37 entries and a close race, we’re happy to announce David Eldersveld, a data visualization and analytics consultant at BlueGranite and author of the DataVeld blog, too home the top prize for his story North Korea – “Handle With Care”. […]

Read More

How many times did you have to work with tables that had headers like these? Client_ID, Transaction_ID, Product_Name, My_DBA_is_in_Love_with_Underscored_Headers This post first appeared at https://datachant.com/2018/02/14/split-camelcase-headers-m/. The author is Gil RavivRead More

Read More

Surfs Up A long time ago a peer in Financial Planning and Analysis said ‘Financial Planning starts in the home.”  I modified the statement to “Data analytics starts in the home.”  This means that I have a host of personal… This post first appeared at https://powerpivotpro.com/2018/02/power-bi-used-for-surfing-fun/. The author is Denton ChaseRead More

Read More

This week we have three great webinars! John Liu on Flowing non Text Data, Jerry Weinstock on using Flow with Dynamics and none other than Reza Rad on Power BI Security! This post first appeared at https://powerbi.microsoft.com/en-us/blog/week-2-13-webinars-advanced-non-text-data-with-flow-dynamics-with-flow-and-power-bi-security/. The author is Read More

Read More

Writing M in the Advanced Editor in Excel or Power BI can be a frustrating experience unless you’re the kind of masochist who loves writing code in Notepad. There are some options for writing M code outside Excel and Power BI, for example Lars Schreiber’s M extension for Notepad++ (see here for details) or the […]

Read More

And another one bites the dust… this month the Power BI team have only delivered the #1 most requested feature on the Power BI Ideas forum.  Synced slicers have arrived!  Now you can apply a user’s selected filter criteria throughout the… This post first appeared at https://powerpivotpro.com/2018/02/connect-one-slicer-power-bi-report-pages/. The author is Mat HerringRead More

Read More

The Power BI service and mobile team is thrilled to kick off the first feature summary blog for 2018! With a new year in full swing, we’ve been hard at work on features to make it easier for you to… This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-service-and-mobile-january-2018-feature-summary/. The author is Read More

Read More

Today I am excited to share a second excerpt from the draft manuscript of my book. Today’s excerpt is the first part of chapter 11, which discusses basic text analytics, and a cool technique to detect multiple keywords in textual feeds using Cartesian Product. To read more excerpts, as they will be published on the […]

Read More

From the Water Cooler As a ‘water cooler’ of sorts for this community, we meet some amazing people. Doug Burke shares with us how easy Power Query makes it to do powerful cleaning with a click of the mouse. The… This post first appeared at https://powerpivotpro.com/2018/02/power-query-magic-right-click-way-data-cleaning-happiness/. The author is Doug BurkeRead More

Read More

Late last year as part of the December Power BI Desktop release, we launched a new connector for data.world – aka the social network for data nerds. data.world is a platform where people can find, use, share and collaborate with a vast array of high-quality open data. This post first appeared at https://powerbi.microsoft.com/en-us/blog/connect-to-tens-of-thousands-of-datasets-on-data-world-with-the-new-connector-for-power-bi-desktop-and-join-the-webinar/. The author is Read […]

Read More

I recently attend a school reunion (class of 1981 for what it’s worth – wow, I’m old!).  We all had a great time catching up, looking at old photos, taking new photos etc – how things have changed!  Anyway that got me thinking that it would be great to do something cool with Power BI […]

Read More

There are two themes for this month’s Power BI Desktop update. The first is a focus on some of your major asks including multi-selecting data points across multiple charts and syncing slicer values across multiple pages of your report. We also have a major update to our SAP HANA connector. Our second theme is a […]

Read More

In this webinar, we cover what is Graph API and how it can provide information and intelligence from Office 365. This post first appeared at https://powerbi.microsoft.com/en-us/blog/2-6-webinar-flow-with-microsoft-graph-api-by-ashish-trivedi/. The author is Read More

Read More

We’ve all met them: the users whose idea of a ‘report’ is a large table of data dumped into Excel. However many beautiful data visualisations they see, however many times you try to convince them of the benefits of using Power BI to build reports, they just want to know where the “Export to Excel” […]

Read More