My name is Sandeep Pawar. I am a Data Science professional. I write about Data Analytics, Data Visualization, Statistics, Machine Learning, Power BI, Azure ML, Python and Synapse Analytics

Posts

• Stripping Off Analysis Services Connection From Multiple Power BI Files

  PowerShell script to strip off analysis services connection from multiple Power BI files at once

  Mar 1, 2023

• Streaming Data From A File To Power BI Streaming Dataset Using Python

  Create streaming dataset based on an existing file using Python. Super handy for POCs.

  Jan 13, 2023

• Fixing the Power BI Deployment Pipeline Error For Migrated Tabular Model With RLS

  How to fix an annoying, cryptic error when using deployment pipeline with tabular AS models migrated to Power BI dataset

  Dec 20, 2022

• Data Science For Power BI Developers

  Recording of the session at Atlanta Power BI User Group

  Nov 9, 2022

• Tabular Editor For Beginners

  I presented an introductory session on Tabular Editor at Delhi Power BI User Group

  Oct 28, 2022

• PowerShell Script To Mass Download Power BI Reports

  A quick PowerShell script to masss download Power BI reports based on a CSV file

  Oct 11, 2022

• Function To Audit Datasources For Query Folding

  Functions to quickly check which of the data sources are folding

  Sep 20, 2022

• Adding Prefix To Selected Columns In Power BI Using Tabular Editor

  Two approaches to add prefix to all the selected columns in Power BI using Tabular Editor

  Aug 30, 2022

• Selectively Highlighting Data Labels in Line Chart In Power BI

  Using conditional color formatting to selectively highlight data labels in line charts

  Aug 12, 2022

• Analysis of Broadband Internet Availability Across the US

  Do communities across the US have same access to high-speed internet ?

  Jul 14, 2022

• Creating Subgroup Ranks in Power Query Using Table.AddRankColumn Function

  Table.AddRankColumn is the latest addition to the M language. This post shows how you can use it to create subgroup rank column

  Jun 21, 2022

• User Feedback Link / Button In Power BI

  Embed link in Power BI reports for users to easily submit feedback via email

  Jun 10, 2022

• Query Folding Safe Data Type Changes

  Simple solution to make data type changes query folding safe

  Jun 1, 2022

• Extracting Matching Words Using A Pre-Defined List in Power Query/M

  Solution to extract words from a sentence in each row using a pre-defined list in Power Query

  Mar 11, 2022

• Relative & Absolute Table Refresh Durations in Power BI

  Few ways to get relative & abolsute refresh durations in Power BI

  Feb 25, 2022