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

• Controlling Marker Size Sensitivity in Scatter Plot in Power BI

  Using parameters to control and tune the size of the markers in Power BI scatter plot.

  Apr 24, 2023

• Controlling Marker Size Sensitivity in Power BI Scatter Plot

  Quick tip to adjust sensitivity of marker size in scatter plot

  Apr 5, 2023

• DAX Measure to Dynamically Offset Datetime Based on Daylight Savings Time

  A quick measure to calculate time based on US Daylight Savings Time

  Mar 29, 2023

• 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