Category

Tutorials

Power Query Function for Dense Ranking

Power Query Function for Dense Ranking Recently I was having issues writing a measure in DAX to rank items properly (not an issue with the DAX, but in my understanding of the DAX). I did some searching and came across Chris Webb's article that had a nice implementation of ranking using Power Query. The technique he proposed uses Power Query to: sort a table by the column you want to rank by, add an index column...

Is this the rebirth of the SharePoint Intranet?

Is this the rebirth of the SharePoint Intranet? With the cloud gaining momentum, the future of the intranet is never far from our minds, or more specifically, the future of the traditional intranet portal. Modern business users want tools that make them more productive and engaged, and they want them in a single, easily accessible location. Microsoft’s SharePoint Server was once billed as an all-round company intranet portal, but it simply doesn’t have the capacity...

Power Query for Azure tables and Updating Column Names

Power Query for Azure Tables and Updating Column Names I recently did some PowerBI work using Azure Table Storage. In the query editor, it seemed that each table I pulled in from Azure Tables had a very similar process.: Get the list of tables available for the storage account. Select a table Select the Content of the table (excluding the RowKey, PartitionKey, and timestamp columns) Expand the columns in the Content Rename the columns Azure...

Step-by-Step Tutorial: IIS Redirect/Rewrites for SharePoint

Step-by-Step Tutorial: IIS Redirect/Rewrites for SharePoint NOTE: THIS IS NOT SUPPORTED BY MICROSOFT, PROCEED WITH CAUTION AND AT YOUR OWN RISK. Perform the following steps on the Web Front End servers only. When working with websites it is imperative to the users, customers and possibly potential customers to be able to locate information when accessing them. Change is inevitable within life just as much as it is in the companies and organizations that employ us....

Scaling Azure SQL Databases Up and Down

Scaling Azure SQL databases up and down   I've recently been working on a project where we push data from an on-premise database to a set of Azure SQL databases daily, and use that Azure SQL database as the source for a Power BI dataset. The dataset gets refreshed once a day. Our Azure SQL data marts are pretty small - all but one of them are under 2 GB, and the largest one is...

How to Ensure Project Success with Telerik (Step-by-Step Tutorial)

How to Ensure Project Success with Telerik Step-by-Step Tutorial Using Imaginet’s Telerik Mastery By: Evan Bosscher At Imaginet, we love being the best at software innovation. While we traditionally have been one of the best in the world on the Microsoft platform for over 19 years, we are never shy about going deep and being world-class experts in other state-of-the-art tools and technologies – especially Telerik technologies. As a Telerik Gold Partner, our Imaginet team…