Select Page

In The Trenches

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

If you have some training budget to spare why not come along to one of the pre-conference seminars/training courses I have coming up in the next few months? Specifically: Introduction to Azure Analysis Services – a pre-conference seminar on Thursday 22nd February at SQLBits 2018 in London. You’ll learn about what Azure Analysis Services is, […]

Read More

Data Ambiguity…The Silent Report Killer Hello P3 Nation, I’m excited to be back and writing a technical post again…it’s been too LONG! Today I want to talk to you about a real-world business problem and solution I encountered last year.… This post first appeared at https://powerpivotpro.com/2018/02/using-selectedvalues-capture-power-bi-slicer-selections/. The author is Reid HavensRead More

Read More

Use a disconnected table in Power BI to show each month and total trailing twelve months (TTM), the total for prior TTM, AND the variance between the two in one matrix table. And conditional formatting! This post first appeared at https://powerpivotpro.com/2018/01/trailing-twelve-months-ttm-power-bi/. The author is Fred KaffenbergerRead More

Read More

In this session, we will summarise the SharePoint features which are being made available in PowerApps. This include, built in support for different field types, new/edit/display forms, built in connectors or rules, connecting to sources or triggering a flow on button clicks. This session will be all around SharePoint and how PowerApps strengthen the SharePoint. […]

Read More

The nice people at PASS have made a video of my session on “Using SSAS MD as a data source for Power BI” available to view for free on YouTube: I’m honoured that it’s listed one of their “Best of PASS Summit 2017” sessions, and there are lots of other great videos on the same […]

Read More

Kudos here will be appreciated. The post 2017 Year-In-Review #PowerBI Contest appeared first on DataChant. This post first appeared at https://datachant.com/2018/01/26/2017-year-review-powerbi-contest/. The author is Gil RavivRead More

Read More

Some people will say that 2017 was the year of the Bitcoin. Whether you have invested in cryptocurrency or not, here is a Power BI tool to play with different What-If scenarios. Select the initial invested amount, set the buy and sell dates, and enter into the time machine to become a millionaire. Click on […]

Read More

We’re excited to announce we’re rolling out report sharing to users worldwide. Now reports and dashboards have the same sharing features, making it even easier for Power BI users to collaborate with their teams and partners. These changes make it possible for users to share reports directly, add reports to their favorites, find it in […]

Read More

From the Water Cooler As a ‘water cooler’ of sorts for this community, we meet some amazing people. Matt Mowrey shares with us a really useful technique to create a discoverable income statement using PowerPivot.  This post runs a little… This post first appeared at https://powerpivotpro.com/2018/01/star-schema-switch-drill-income-statement-design/. The author is Matthew MowreyRead More

Read More

Changing Defaults In March 2017, the Power BI team delivered a new feature that allowed you to change the colour defaults in a Power BI report using a custom colour theme.   I wrote a blog post over at PowerPivotPro.com at the time.   The drawback of this feature, as it was back in March, was that you needed to […]

Read More

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

Read More

GUESS WHO’S BACK, BACK AGAIN Krissy’s back, tell a friend! Guess who’s back, Guess who’s back, Guess who’s back. Guess who’s back… Well, as probably most of our readers know, Rob is well known for a GOOD movie reference in… This post first appeared at https://powerpivotpro.com/2018/01/consecutive-days-back/. The author is Krissy DyessRead More

Read More

It may not be immediately obvious, but you cannot set your own connection string properties when connecting to SQL Server using the built-in SQL Server connector from either Power BI or a modern data source in Azure SSAS/SSAS Tabular 2017: All you can do is configure the options that are available in the UI, which […]

Read More

This is a quick post to share a few scripts to find what is currently executing in Azure Data Factory. These PowerShell scripts are applicable to ADF version 1 (not version 2 which uses different cmdlets). Prerequisite: In addition to having installed the Azure Resource Manager modules, you’ll have to register the provider for  Azure […]

Read More

See all the interactions between Excel and Power BI (Power BI in Excel, Excel connector, Power BI Publisher for Excel, Analyse in Excel, Export to Excel, push Data model from Excel to Power BI Service) with practical examples and relevant scenarios. Where: https://www.youtube.com/watch?v=sM8xkNyZaTU This post first appeared at https://powerbi.microsoft.com/en-us/blog/jan-18-the-powerful-interactions-between-excel-and-power-bi-by-tristan-malherbe/. The author is Read 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/01/coffee-talk-dax-pros/. The author is Austin SensemanRead More

Read More

I am working on the second submission for Power BI 2017 Year in Review contest. Here is a sneak peak… If you are a K-pop fan, or have teenage kids at home who love BTS, this report can be useful to bring young generation music and analytics together. Stay tuned for updates including the PBIX […]

Read More

Quick update for those of you who use this DataChant Facebook report. You may experience the error (#2) Service temporarily unavailable, when you refresh the report. This is a known Facebook bug. I will let you know once there is a workaround, or a fix. This post first appeared at https://datachant.com/2018/01/17/facebook-bug-2-service-temporarily-unavailable/. The author is Gil RavivRead More

Read More

Vishwas will showcase a PowerApp application that is essentially a “portal” for existing Line of Business Enterprise Applications (inventory, contracts etc.) and Services ( Dynamics, O365, DropBox etc. )Through the use of PowerApps features like the out of the box connectors, integration with Flow and mobile enablement, learn how easy it is to build an […]

Read More

My Story, My Journey, My Passion Buckle in folks, this is going to be a long and engaging article. As we enter 2018, I realized that I’m approaching the one-year anniversary of my first blog post here at PowerPivotPro! So… This post first appeared at https://powerpivotpro.com/2018/01/my-journey-to-powerpivotpro/. The author is Reid HavensRead More

Read More