Category: Azure

Calculation Groups with Disconnected Tables in Power BI/AAS

Below I will explain how to use Calculation Groups with Disconnected tables. I know that some of this might be able to be done with other calculation groups. I find I have more flexibility when combining Calculation Groups with a disconnected table. Below are some of my previous calculation group blog posts that might also be of interest: Create Currency…

Create Currency Formatting Strings using Calculation Groups in Power BI Pro & Premium / Azure Analysis Services / SQL Server Analysis Services 2019

Below are the steps on how I got the calculation groups to work for Currency formatting strings when the currency format string will be displayed per currency shown. Following on from my previous blog post (How to create and use Calculation Groups in Power BI Pro & Premium / Azure Analysis Services / SQL Server Analysis Services 2019) on how…

AAS (Azure Analysis Services) / SSAS Tabular -Using BISM Normalizer to NOT Overwrite existing Partitions

I had partitions already configured and running on my AAS model. Partitions allow you to process only the data that needs to be updated. I have certainly done it in the past whereby mistake I updated all the partitions, which would mean I would then need to re-process them. This would not only take a lot of time (due to…

BI-NSIGHT – Power BI (Embedded Preview, Data Insights Summit Day two, Desktop Update, Power BI Publisher for Excel, KPI App for Apple Watch, R in Power BI Webinar, Content Packs Intelliboard & Ziosk) – Azure Data Catalog (Generally Available)

So after my last blog post the Data Insights Summit came to a close with a whole host of new features and future things to look forward to. As well as then Microsoft already releasing what they had promised in the typical Power BI fast paced manner. So here are this week’s updates in the world of Business Intelligence Power…

BI-NSIGHT – Power BI (Q&A for SSAS Tabular, Weekly Service Update, Lithium Content Pack, Mobile App for Windows 10 Mobile) – Azure (SQL Server Virtual Machines) – Power BI and Leveraging the Cloud

Even though I think a lot of people took time off over the Christmas period it seems that the Power BI team at Microsoft was full steam ahead. Which is a great thing to come back to work and have all these updates and new things to look into. Power BI – Q&A for SSAS Tabular The reason for me…

BI-NSIGHT – SQL Server 2016 (CTP 3.1, SSAS Tabular) – Power BI (Cortana, Mobile App, Enterprise Gateway, Bing Content Pack, API Updates, Sentiment Analysis) – Data Insights Summit – Power Apps

Once again this week there has been a lot of activity in the BI space. Which is great and is definitely keeping me on my toes! SQL Server 2016 – CTP 3.1 & SSAS Tabular This week Microsoft released a small update to SQL Server 2016, and one of the features that I am looking forward to testing is upgrading…

BI-NSIGHT – Power BI (Pin Excel Range to Dashboard, Weekly Service Update, New Custom Visualizations, Power BI Community, R, VMOB Content Pack) – Azure (Data Science Virtual Machine)

So I have been offline for a little while, quite a few things going on, but I am back on track and here are the latest BI-NSIGHT updates that I have been looking into! Power BI – Pin Excel Range to Dashboard It is really great to see that the Power BI team is realizing that having the ability to…