Select Page

In The Trenches

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

The April 2018 release of Power BI Desktop included a new M function: Binary.InferContentType. There’s no online documentation for it yet but the built-in documentation is quite helpful: I tested it out by pointing it at the following simple CSV file: This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/YM4bAHHKhDQ/. The author is Chris WebbRead More

Read More

The Power BI team at Microsoft is hiring. We’re looking for amazing people to join our world class team. Read this blog to learn more about our team and see the list of open jobs. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-is-hiring/. The author is Read More

Read More

Two great Webinars for the week of 4/11: Load Testing Power BI Applications with Visual Studio Load Test and Getting Started with CDS for Apps based Model Driven Apps This post first appeared at https://powerbi.microsoft.com/en-us/blog/week-4-11-webinars-load-testing-power-bi-applications-with-visual-studio-load-test-and-getting-started-with-cds-for-apps-based-model-driven-apps/. The author is Read More

Read More

I think Power BI’s a great tool, but like most Power BI users I have a list of my own pet features that I would like to see implemented to make Power BI even greater. What I would most like to see addressed is the fact that, right now, Analyze In Excel only works with […]

Read More

This month, on top of our normal of visual & data connector improvements, we have two exciting features that lets report consumers interact with reports in a new way. The Q&A Explorer enables report consumers to ask their own questions about the data, and buttons let you add interactive elements on your reports. This post […]

Read More

My name is Mathew Herring Jack, and I am a member of Traditional Excel Users Anonymous. As a Traditional Excel User, I could not stop copying and pasting downloaded reports. Even when my manager diagnosed me with inaccurate month-end reporting,… This post first appeared at https://powerpivotpro.com/2018/04/the-great-function-project-part-2/. The author is Mat HerringRead More

Read More

Ken Puls is coming again to Australia and once again he has generously offered to speak at the Sydney Power BI User Group.  This time ‘round Ken will be talking on a broad topic around how Power BI and Excel are increasingly being enhanced to work together.  Microsoft calls this “Power BI and Excel – […]

Read More

This, 4/2/2018 brings you two free great Power BI Webinars: Practical DAX for Power BI with Phil Seamark and Developing with Power BI Embedding – The April 2018 Update by Ted Pattison! This post first appeared at https://powerbi.microsoft.com/en-us/blog/week-of-4-2-two-great-webinars-practical-dax-for-power-bi-and-power-bi-embedding-the-april-2018-update/. The author is Read More

Read More

We are excited to announce that we have just released the March update for the On-premises data gateway. Here are some of the things that we would like to highlight with this month’s release: The… This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-march-update-is-now-available/. The author is Read More

Read More

My 2010 Wake Up Call Eight years ago, I lucked into an epiphany: IT-driven BI was going to give way to biz-driven BI (aka “self-service” or “Agile” BI). The new wave of BI tools – led by Power Pivot at… This post first appeared at https://powerpivotpro.com/2018/03/agile-bi-moves-from-if-to-how/. The author is Rob CollieRead More

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-march-update/. The author is Read More

Read More

Webinar: Power BI Tricks, Tips and Tools from the owners of PowerBI.Tips Mike Carlo and Seth Bauer This post first appeared at https://powerbi.microsoft.com/en-us/blog/3-28-201-webinar-power-bi-tricks-tips-and-tools-from-the-owners-of-powerbi-tips-mike-carlo-and-seth-bauer/. The author is Read More

Read More

BI Survey 18

Mar 28, 2018 | Chris Webb

It’s that time again: the BI Survey (the world’s largest survey of BI tools and users) needs your input. Here’s the link to take part: https://www.efs-survey.com/uc/BARC_GmbH/396b/?a=101 This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/lcw5AfLwOnQ/. The author is Chris WebbRead More

Read More

I often have inputs I know today and want to “run them out” into the future applying certain parameters along the way to create a projection. I’m in finance, so my needs will almost always have a financial planning bias,… This post first appeared at https://powerpivotpro.com/2018/03/using-dax-magic-for-variable-forecasting/. The author is Matthew MowreyRead More

Read More

In the healthcare industry, the HITRUST Common Security Framework was developed to help address the multitude of security, privacy and regulatory challenges facing organizations today. Developed by IT and healthcare professionals, the CSF provides a highly prescriptive framework for managing a diverse set of federal and state regulations, standards, and frameworks. Today, Microsoft is pleased […]

Read More

In a tweet storm, Elon Musk said he’s deleting Tesla and SpaceX Facebook accounts (Source here). Tesla Facebook page is indeed out. Luckily, I have recently prepared this report on Tesla Facebook page – a memento to remark this milestone event in the history of social networks. Enjoy the report. Click here to view the […]

Read More

Facebook is facing great challenges lately here. The latest privacy scandal, involving Trump campaign consultants who allegedly stole data on 50 million users in order to influence elections, is yet another crisis following very tough two years that may have shook its foundation. To protect their users, and avoid misuse of user information, Facebook have made […]

Read More

There have been a lot of important Power Apps and Flow announcements today, as well as the announcement about the Common Data Service for Analytics which is undoubtedly massive news for Power BI users, but buried in the very large “Dynamics 365 Spring ‘18 Release Notes” pdf file (downloadable from https://aka.ms/businessappsreleasenotes) are a number of […]

Read More

New capability reduces the time, complexity and cost of extracting intelligence from disparate data sources. This post first appeared at https://powerbi.microsoft.com/en-us/blog/coming-soon-to-power-bi-common-data-service-for-analytics/. The author is Read More

Read More

It’s time again for the March Madness tournament and another excellent opportunity to introduce/teach people at your company/organization about Power BI.  This article explains one approach for doing March Madness Power BI style, and using everyone’s bracket data to teach… This post first appeared at https://powerpivotpro.com/2018/03/march-madness/. The author is Patrick MahoneyRead More

Read More