Power Query and SQL Server Stored Procedures
Today I want to explain how you can pass parameters to a SQL Server stored procedure. I myself was looking…
Creating a Simple Date Dimension Using Recursive Common Table Expressions (CTE)
In this post I’ll explain how to create a simple date dimension to use it in your data warehouses and…
Resolving “Object reference not set to an instance of an object.” Error When Deploying your Tabular Model
You’ve changed something in your Tabular model and you’re facing an ugly “Error: Object reference not set to an instance…
How to Automate SSAS Tabular Model Processing
You are working on a BI project that involves SSAS Tabular model. As you cannot process the model manually you…