Nisal Mihiranga's Blog

The Best practice rules to improve the Power BI and Tabular model’s performance a comprehensive guide has been released by the Power BI Team. This list of rules contains best practices for Performance, Maintenance, DAX coding, etc. You can access it from Best practice rules to improve your model’s performance   published on the official site.

 Conduced a 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 hands-on training program to the students from 𝗨𝗻𝗶𝘃𝗲𝗿𝘀𝗶𝘁𝘆 𝗼𝗳 𝗖𝗼𝗹𝗼𝗺𝗯𝗼. Taught them how to cleanse and perform an analysis atop raw data within a few minutes using Microsoft Power BI, which is an essential skill set required to pursue nowadays. There were 180+ students who participated in the training.

This is the simplest method to get the row counts of all tables in your SQL Server database. Might be useful when you are doing the data testing over your BI project.     select   schema_name (tab.schema_id) , tab.name  as  [table],         sum (part.rows)  as  [rows]     from  sys.tables  as  tab          inner join  sys.partitions  as  part              on  tab.object_id  =  part.object_id where  part.index_id  IN  ( 1 ,  0 )  //   0 :  Table   without  PK,  1 :  table   with  PK and   schema_name (tab.schema_id)  =   'dbo'   group by   schema_name (tab.schema_id) , tab.name --order by sum(part.rows) desc  

Role-playing dimensions are one of the key concepts in Data Warehousing and Business Intelligence development. If you are not familiar with it you can read James Serra 's Blog article on Role-Playing Dimensions from here In this article, I'm going to demonstrate to you How to Analyse Measures by using Role-Playing Dimensions Effective manner . If you are familiar with Relationships in Power BI you know by now, you cannot create two active relationships simultaneously  with the same tables in a Power BI model. You must make one relationship Active while other relationship's inactive.  For this Demo, I've taken the WideWorldImportersDW demo database. So you can download it from here for free. For simplicity, I only have taken the Sales and Date table and imported it into Power BI.  You can see in this data model we have a  Sales transaction fact table and Date dimension table. If you looked closely the Sales table contains two Date columns, Invoice Date and Deliv...

I'll show you how to set up and install Power BI on your Windows personal computer in this little blog post. Sadly, macOS and Linux distributions are not supported by Microsoft Power BI Desktop. I've seen that not everyone finds it simple and easy to install the Power BI desktop. Therefore, by sharing this, I hope to encourage you to download Power BI for your computer and begin your data analytics journey. Power BI Desktop Option #1: Download via Windows Store (recommended)  1. To install the Power BI desktop can be done using Go to Microsoft Store-> Search Power BI Desktop  2. Then select the Power BI Desktop App 3. Click the Get button to install the Power BI Desktop app on your PC 4. It will take a few seconds or minutes depending on the network bandwidth. However, you can see the progress during the download and installation time. Once it is completed, you can see there is a Launch button appearing to Launch the application.  Option #2: Download via the Inter...

Problem It was a horrible experience with a busy day. Suddenly the Developer Database, presumably Azure SQL Serverless Database went off. In another word, it was in Auto-pause mode.  When I search through the internet, I couldn't find any reliable method of turn it back to accessible or resume mode. According to the documentation , If I login to the database then it should be turned it back, but it is not the case. I tried with both Management Studio and Azure Data Studio those options were not in my favor. Solution Unfortunately, the solution is pending. Unless you have to trigger manually by doing one of the tasks was in the list I've referenced above. I found that this feature is started to develop, according to the Microsoft Azure forum . But, that is not helpful to get sorted my issue today. Workaround  Maybe if you are an Application developer you might not get this issue. Perhaps if you invoke some function which hit to the database, this problem wi...

When you working with Tabular modeling projects you may encounter this problem. How we can filter multiple cell values that are in the same column using DAX for creating measure. Scenario: Let's say you have a table with Sales data as below. Which contains Product information and sales amounts. Assume, you have a requirement to create a Calculated Measure to filter only Clothing and Accessories . Of course, you can do this using a filter pane as shown below. Remember this requirement is not to have multiple predicates with different columns but, in the same column. Solution: We can write a DAX code like this to solve this problem. In here I create a Calculated Measure called Other Products  which filters all the records in Sales query for Category Accessories and Clothing . EVALUATE CALCULATE  (      SUM  (  Sales[Sales Amount]  ) ,      FILTER  (  Sales, Sales[Category]  IN ...