Select Page

In The Trenches

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

A few weeks ago I wrote an article introducing dataflows in Power BI and discussed why you should care about them.  There are a few questions that have been spinning around in my head since then, significantly: What implication is there to the Power BI Golden Dataset as a result of the new dataflows? and Should […]

Read More

Have you ever needed to get data out to an internal customer quickly to meet an urgent business need, in an easy to access, updateable format? Of course! There are lots of ways to do this, and I’ve tried various… This post first appeared at https://powerpivotpro.com/2018/11/a-different-use-for-power-bi-self-service-refreshes-and-extracts-to-excel-while-managing-security-in-power-bi/. The author is Helen ClarkeRead More

Read More

One of the most common issues faced when calling web services in M is that the the easiest way of doing so – creating a function that calls the web service, then calling the function once per row in a table using the Invoke Custom Function button – is very inefficient. It’s a much better […]

Read More

Today marks the 20th birthday of Analysis Services: it was released (as OLAP Services) on November 16th 1998. There’s a celebratory blog post and video over on the Power BI blog here: https://powerbi.microsoft.com/en-us/blog/analysis-services-is-20-years-old/ This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/jwf3C611nd0/. The author is Chris WebbRead More

Read More

We are happy to announce that we have just released the November update for the On-premises data gateway (version 3000.0.155.1)            &… This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-november-update-is-now-available-2/. The author is Read More

Read More

Happy 20th birthday Analysis Services! This post first appeared at https://powerbi.microsoft.com/en-us/blog/analysis-services-is-20-years-old/. The author is Read More

Read More

The new modeling view in Power BI Desktop is designed to work with enterprise datasets that grow in complexity This post first appeared at https://powerbi.microsoft.com/en-us/blog/modeling-view-in-power-bi-desktop/. The author is Read More

Read More

This is the second bonus exercise for my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. Follow @gilra This post first appeared at https://datachant.com/2018/11/15/preserve-context-csv-file-bonus-exercise-chapter-5-powerquery-book/. The author is Gil RavivRead More

Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/help-shape-the-future-of-power-bi/. The author is Read More

Read More

Dataset size and dataset count in memory are now available in the app This post first appeared at https://powerbi.microsoft.com/en-us/blog/dataset-size-and-count-now-available-in-power-bi-premium-capacity-metrics-app/. The author is Read More

Read More

The ability to add columns and measures to display folders in the new Modelling view is one of my favourite features of the November 2018 release of Power BI Desktop: it makes complex models a lot more user-friendly. Being an old-school SSAS developer, I immediately wondered if they worked in the same way that they […]

Read More

At Microsoft, our mission is to empower every person and every organization on the planet to achieve more. Power BI makes it possible for every employee in an organization to make better decisions based on data with beautiful reports and dashboards. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-announces-new-ai-capabilities/. The author is Read More

Read More

This is a question I get fairly regularly these days: Should we extract relational data and load it to a data lake? Architecture diagrams, such as the one displayed here from Microsoft, frequently depict all types of data sources going thru the lake: This post first appeared at http://feedproxy.google.com/~r/SqlChick-MelissaCoates/~3/T-xJxUz5sC8/when-should-we-load-relational-data-to-a-data-lake. The author is Melissa CoatesRead More

Read More

Navigating the sea of data One of the many things which amaze me about Power Pivot time after time is its ability to effortlessly convert raw data into crucial information as soon as it happens. For example, receivables not being paid… This post first appeared at https://powerpivotpro.com/2018/11/reducing-dso-using-power-pivot/. The author is Sakiko StickleyRead More

Read More

We have a massive Power BI Desktop update this month. Composite models, which allow you combine direct query and import sources together in one model, is now generally available. Two of the top feature requests on UserVoice, expand/collapse on the matrix and copy and pasting visuals between Desktop files, are also shipping this month. We […]

Read More

The idea of creating a Power BI custom connector for the Power BI REST API is not a new one: Miguel Escobar wrote one earlier this year (see here for the source code and documentation). However the Power BI REST API has a lot of endpoints so writing code to support them all would be […]

Read More

I was chatting to my wife the other day discussing all the things we want to do next year. It has long been a pain in the butt to get a high level (big picture) view of your Outlook diary to see what is happening (think forest, not trees).  In the past I have used […]

Read More

Microsoft recently released a new feature in Power BI called “Dataflows”.  You may have seen it pop up in a recent release of Power BI Desktop under HomeGet DataPower BI Dataflows (beta) as shown below. It is also visible when you log into PowerBI.com and go to an App Workspace as shown in 1 below.  […]

Read More

Earlier this year I published a survey to assess the impact of Power Query in organizations. I have decided to publish this survey again, and share the results with you by end of 2018. This time you can also share your own story on DataChant. Take this opportunity to share your story, and help spread the […]

Read More

It’s sometimes difficult to find things that Power BI can’t do. There always seems to be a solution no matter the task at hand. A little while ago I was wondering to myself if it was possible to embed a… This post first appeared at https://powerpivotpro.com/2018/11/dynamically-embedding-web-pages-in-power-bi/. The author is Parker StevensRead More

Read More