Power BI Service allows you to refresh your model completely but sometimes that's not what you want specifically when you are making...

Here is PowerShell script that adds a particular user or a group to all the workspaces in a tenant. The Where-Object method filters the...

Here is a code that exports measures from Power BI Desktop, Power BI Service, or Analysis Services Tabular On Premise using C#. //...

I was looking for a good week based date table on Internet and found only 1-2 but I didn't find columns that I needed, so my search ended...

Model.bim is a JSON file which is the skeleton of your Power BI or SSAS Model, using this file you can create a database from scratch,...

In this blog let's take a look at how you can use the Model.bim file extracted either from SSAS Tabular, Power BI Desktop or Power BI...

As the title suggest let's see how to publish multiple reports to Power BI Service with PowerShell. First order of buisness is to ensure...

Here is a Python script that allows iterates over a YouTube playlists. The current limitation is that I have to prepare a dictionary with...

I this blog I want to show how you can use the Contoso Generator from SQLBI - Contoso Data Generator There are quite a few options that...

A common issue that I have faced consistenly is that when expanding columns that contains tables in Power Query the data types of the new...

Someone asked on Power BI Service on how to get all reports across all Premium workspaces so I started reading documentation and found...

If you work with Power BI and SSAS Tabular one thing to know is that there are 2 engines in Analysis Services i.e. Formula & Storage...

In this blog let's take a look at the performance of a report when you use a Measure in the Filter Pane. Let's say you have a data model...

Recently I faced a situation where a simple measure such as COUNTROWS was returning a blank, yeah what's up with that? COUNTROWS...

DAX language of Power BI and SSAS Tabular doesn't have a function for Full Outer Join so in this blog we are going to see a work around...

In this article let's take a look at how to get started with aggregations feature in Power BI. I will try to explain aggregations in a...

In this blog let's take a look at how you can use Python to connect to either Power BI or SQL Server Analysis Services to run DAX...

Last year we released a course on one of the most famous development tool for Power BI, check out the interview I had with EDNA.

Recently someone asked a question that whether they should store a column in a Tabular model in String or Integer format and in this short blog I just want to help you decide it by yourself. In Power Query I have create 2 tables with different data types Let's load these tables in the data model and open DAX Studio and view the vertipaq Analyzer metrics. We can see that both column have a Dictionary encoding: The size of the dictionary varies however, the overall size mention

Have you ever writen a piece of DAX Code that looks like this: and ended up confused how is it able to calculate how many years, days,...

In this blog lets see how we can implement OLS or Object Level Security in Power BI. In simple terms the difference between RLS and OLS...

Having a complete date table in your SSAS model is extremely important, a complete Date table helps in ensuring that the time...

A very common scenario in Power BI is of extracting measure into text file and then loading them back again in the Power BI file so that...