Unfortunately, it does happen… You have just added a new calculation group/calculation item to your model and all of the sudden, some of the visuals on your report stop working. Usually, the main reason behind is some sort of invalid DAX in your calculation group. However, sometimes this might happen even if on a surface … Continue reading What to Do When Calculation Groups Break Your Measures (PowerBI Tutorial)
Category: Analysis Services
Is Snowflake One Bad Quarter Away from Being Microsoft Power BI Biggest Threat?
I suspect that many of you have looked at the title of this video and immediately thought that I was just being silly and provocative. And, generally speaking, you would be right as I do enjoy a fair amount of silly and provocation every now and then. However, in this case, even though I do … Continue reading Is Snowflake One Bad Quarter Away from Being Microsoft Power BI Biggest Threat?
KNOWLEDGEBANK.PRO VLOG #2: Channel Update, Two Custom Visual Reviews and a Bit of Ranting
Vlog #2 is up… I talk about the channel growth – 10% in the last week – thank you! I also go over the latest Power BI updates from the team's blog. Basically, nothing super exciting, other than a few cool things that get us closer to a direct query to AS or PBI composite … Continue reading KNOWLEDGEBANK.PRO VLOG #2: Channel Update, Two Custom Visual Reviews and a Bit of Ranting
Optimizing Azure Analysis Services Partitions for Azure Data Warehouse External Tables
Recently, I had a chance to work with Azure Analysis Services (AS) sourcing data from Azure Data Warehouse (DW) external tables. Optimizing the processing of the Azure Analysis Services partitions to use with the Azure DW external tables is a bit different from working with the regular (physical) data tables, and I will discuss the … Continue reading Optimizing Azure Analysis Services Partitions for Azure Data Warehouse External Tables
Quirks of Visual Studio Query Editor working with Analysis Services
Visual Studio 2017 and the SQL Server Data Tool (SSDT), a tool that comes with Visual Studio, finally integrates the now familiar Query Editor (Power Query) capability to work with the Analysis Services Tabular Model. Query Editor is a data ingestion and transformation tool used by Excel Power Pivot as well as Power BI. Now, … Continue reading Quirks of Visual Studio Query Editor working with Analysis Services
Check List for Running Analysis Services in Azure for Power BI
This comes up a lot so I wanted to make a quick check list of steps necessary to run SQL Server Analysis Services in Azure and expose it as a data set in Power BI. Create a new VM in Azure Join the new VM to your corporate domain (may require networking configuration and VPN … Continue reading Check List for Running Analysis Services in Azure for Power BI
Adding an Index Column to a Power Pivot Model using EARLIER() DAX Function
This post will be a little bit atypical compared to what I normally write about. I usually don't focus on topics like the one described below because there are plenty of other blogs that cover developer specific issues related to using DAX. However, I ran into an issue few days ago, could not find a … Continue reading Adding an Index Column to a Power Pivot Model using EARLIER() DAX Function
SQL Server Data Tools (SSDT-BI) for Visual Studio 2013 are back and available for download
SSDT-BI were down for almost a month after the release of the SQL Server 2014 causing a lot of frustration to the end users who were trying to develop BI solutions using Visual Studio 2013. No point of getting into the reasons why, let's just take a deep breath and download the latest version here … Continue reading SQL Server Data Tools (SSDT-BI) for Visual Studio 2013 are back and available for download
PowerView can now connect to multidimensional models
The cumulative update 4 for the SQL Server 2012 Service Pack 1 has now been released. This update enables PowerView to connect to Multidimensional models and also to have global filters across multiple views (pages) in a PowerView report. Please follow this link for more details http://blogs.msdn.com/b/sqlrsteamblog/archive/2013/05/31/power-view-for-multidimensional-models-released.aspx
Some comments on the CTP of the Microsoft SQL Server 2012 With PowerView For Multidimensional Models
I have had a pretty frustrating experience with it so far. I think that the only way get it to work is to have it deployed as a SSRS Service Application inside SharePoint and then configure PowerView. In other words, if you are planning to install a multidemensional instance of the CTP, install your OLAP cube … Continue reading Some comments on the CTP of the Microsoft SQL Server 2012 With PowerView For Multidimensional Models
business intelligist 