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…
Creating a Power BI Report from the Audit Logs stored in Azure Blob Storage
Following on from my blog post on How you can store All your Power BI Audit Logs easily and indefinitely in Azure, I wanted to share with you how I connected to the Blob Storage Files and created my Power BI report, to report on the audit logs. Pre-requisites Before starting with the Power BI report, I first had to…
How to configure Azure Function App notifications for errors
Below are the steps to enable error notifications on Azure Function Apps Follows on from my previous blog post How you can store All your Power BI Audit Logs easily and indefinitely in Azure, where every day it extracts the Audit logs into Azure Blob storage. One of the key things when working with any job that runs, is that…
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…
Power BI and Leveraging the Cloud (Microsoft Azure)
Whilst there is a lot of information about Power BI and Azure I thought it would be good to see how Power BI leverages the cloud namely Azure. Personally I have read up and am well aware of what Azure has to offer. I am sure that I am not alone, in that often I think is Azure really as…
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…