Select Page

In The Trenches

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

Last week, while I was taking a few days holiday from work, Avi Singh interviewed me via Skype and asked about my journey into Power BI.  I have written about that over at PowerPivotPro.com originally here and then 3 years later here, but this is the first time I have talked about it on a […]

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/06/coffee-talk-ectobox/. The author is David HarshanyRead More

Read More

In the June 2018 release of Power BI Desktop there were a number of improvements made to the way the Power Query engine handles OData data sources. You can read about them here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-2018-feature-summary/#oData This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/S_G_PsWs4CE/. The author is Chris WebbRead More

Read More

  Humans like turning a few things into many things. Investing $1 to get $10 . . . growing saplings into oaks . . . taking two rabbits and creating a fluffle. This post will show you how to do… This post first appeared at https://powerpivotpro.com/2018/06/powerquery-magic-combine-m-functions-and-formulas-in-custom-columns/. The author is Doug BurkeRead More

Read More

Level: Intermediate I got my haircut today (pretty spiffy one too, even if I do say so myself).  While I was chatting I asked my hair dresser “on average, how often should I get my hair cut”?  She told me (for men) around 4-6 weeks.  Then I got thinking (as I do), I wonder if […]

Read More

It’s almost here, the first-ever Microsoft Business Applications Summit, coming to Seattle July 22 – 24. Don’t miss out! Register today for two info-packed days of amazing sessions, networking opportunities and expert meet-ups. This post first appeared at https://powerbi.microsoft.com/en-us/blog/time-is-running-out-join-our-community-partners-and-experts-at-microsoft-business-applications-summit/. The author is Read More

Read More

SQL Transactions

Jun 25, 2018 | SQL Girl

Transactions in SQL Server are very useful, however I have come across that not many people use them. Not sure why this could be, so thought I would share how transactions work and the different modes. A transaction is a single unit of work. If a transaction is successful, all of the data modifications made […]

Read More

Sometimes you need to automate the upload of a file to an FTP or SFTP. Thought I would share the way that I use the SFTP task in SSIS to upload files. Firstly create the variables to use in the SFTP task. Variables are an easier way to manage things without going into the task, […]

Read More

The recent blog post on the Analysis Services team blog about new memory options contained information about some very interesting functionality that has just been added. The first of the new features I decided to try was the RowsetSerializationLimit server property, which restricts the number of rows returned by a query and which is intended […]

Read More

Conditional Formatting Using Text In Power BI Desktop Hello P3 Nation! Today’s “post” is actually going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written word, and… This post first appeared at https://powerpivotpro.com/2018/06/conditional-formatting-using-text-in-power-bi-desktop/. The author is Reid HavensRead More

Read More

Following on from a previous post of how to set up Master Data Services (MDS) with IIS, this post is about setting up permissions in MDS 2016. In previous releases, you had to choose a Windows account during the installation and configuration of the MDS database. This account would become a system-wide administrator and have […]

Read More

Answer this short survey to estimate the potential of Power Query. Once we have enough answers, I will publish the results below, and over time we will use the wisdom of the crowd to help us figure out the real potential of Power Query.  This post first appeared at https://datachant.com/2018/06/20/the-potential-impact-of-powerquery-a-crowd-wisdom-survey/. The author is Gil RavivRead More

Read More

Intro When was the last time you had an interview with the president of the company and he was wearing shorts and a t-shirt while you were decked out in a suit? Swing back to June 2017, and that was… This post first appeared at https://powerpivotpro.com/2018/06/journey-to-powerpivotpro-narayana-windenberger/. The author is Narayana WindenbergerRead More

Read More

You will notice when setting up MDS for the first time that it will use your AD account by default. This can become a problem if you leave a company and you are the System Administrator for MDS. When your AD account gets disabled by your workplace MDS will stop working, so best to set […]

Read More

The ZIP file task is a great feature that SSIS has for when you need to move/email a large amount of data. Also if you have multiple files you want to move to the same location, this makes it easier for you, so you can move just one file instead of many. I prefer to […]

Read More

This post first appeared at http://feedproxy.google.com/~r/SqlChick-MelissaCoates/~3/W36GnXy5KZg/terminology-check-what-is-a-power-bi-app. The author is Melissa CoatesRead More

Read More

The other day I discovered something new (at least to me) while writing the DAX for a measure in Power BI Desktop: when you insert a new line in your DAX expression using SHIFT-ENTER it also auto-indents the code. I asked a few people if this was new because I was sure I hadn’t seen […]

Read More

Recently I came across an issue where I needed to set an alert that when a report is populated it needs to send out an alert. Unfortunately in SSRS you can only do subscriptions and I have not found a way to do those kinds of alerts on an SSRS report. A workaround I found […]

Read More

Get ready to connect, collaborate and pack in as much learning as possible at Microsoft Business Applications Summit, the event for Dynamics 365, Power BI, Excel, PowerApps and Flow users, July 22-24 in Seattle. We’ve just announced our featured speaker lineup – you won’t want to miss these experts, plus three amazing keynotes. Check it […]

Read More

This week have another Australian join me to cover off one of my favorite topics….using PowerApps and Flow to deliver business applications that traditionally require a development and devops team! This post first appeared at https://powerbi.microsoft.com/en-us/blog/6-14-webinar-inside-the-universal-audit-app-see-what-powerapps-and-flow-are-capable-of-by-paul-culmsee/. The author is Read More

Read More