Power BI Analytics Kingdom | Blog

How to Use SQL Window Functions to Analyze Transactional Data with Permutations and Combinations Scenario: Suppose you are working with a fi...

How to use Power Query to Handle Composite Headers Dynamically from Excel to Power BI Scenario: Suppose we have a sample of FTE data in an E...

How use Power Query to return the Last Refresh Date of SQL Tables in Power BI Scenario: We have a set of tables/views sourced from Azure SQL...

How to Identify the duplicate Values in a Column using Power Query Scenario: Suppose, we have a dataset( ds_Sample ) as below with duplicate...

How to Switch Source Query Connection Strings in Power BI with Dynamic Query Parameters Scenario: To manage multiple data or query environm...