Power BI Personal Gateway supplemental information

Note: Power BI software is updated frequently. This is written based on the Power BI Personal Gateway released in August 2015. Power BI Personal Gateway allows refresh of data models stored in Power BI that connects to an on premise data source. Power BI support has 2 documents on how to install and troubleshoot this…

2

SSAS MOLAP dimension size limit

After the introduction of the StringStoresCompatibilityLevel property in SSAS dimension after SQL Server 2012, SSAS database designer may try to create a MOLAP dimension with more unique values than what is allowed in previous SQL Server versions. The article Configure String Storage for Dimensions and Partitions has a very good documentation of this property. The…

0

SSIS execution time out error when using SSISDB stored procedure [catalog].[create_execution]

After SQL Server 2012 is released, SSISDB provides stored procedures to create SSIS package executions. There is one problem though. If too many package executions are created a the same time, you may get the following error “The operation failed because the execution timed out” The cause is in the stored procedure [catalog].[create_execution]. It throws…

1

Error in MDX query result cell is not shown in SSRS query designer

This is a very little known problem regarding how SSRS query designer having trouble showing cells with MDX error. I created an MDX query to create a result cell that shows an error with member measures.ErrorCell as [somethingbad] select measures.ErrorCell on 0 from [Adventure Works]   If you run the following MDX query in SSMS…

0

Performance problems on high cardinality column in tabular model

Marco Russo has a great article regarding optimization on high cardinality column in tabular model at Optimizing High Cardinality Columns in VertiPaq The basic idea is to avoid having high cardinality columns in an SSAS tabular model database. The reasons are 1. It takes a long time to process a high cardinality column. If you…

2