Sandeep Pawar
@PawarBI
Followers
4,593
Following
1,174
Media
1,049
Statuses
11,045
Power BI | Microsoft Fabric | Data Platform MVP | Exploring the intersection of Data Analytics, Data Science, LLM | 🇮🇳🇺🇲 | ☕🏏
Portland | Chicago | पुणे
Joined March 2008
Don't wanna be here?
Send us removal request.
Explore trending content on Musk Viewer
Carvajal
• 350773 Tweets
Ford Foundation
• 98212 Tweets
Nairobi CBD
• 88535 Tweets
連休明け
• 86678 Tweets
プライムデー
• 77643 Tweets
Amber Rose
• 75907 Tweets
Tubiana
• 67451 Tweets
#Maandamano
• 58521 Tweets
#yks2024
• 47860 Tweets
Kericho
• 42262 Tweets
عمان
• 38748 Tweets
Seonghwa
• 35087 Tweets
जम्मू कश्मीर
• 30662 Tweets
जवान शहीद
• 26500 Tweets
アイカツ
• 23959 Tweets
Big Wiz
• 21063 Tweets
#Compact
• 19063 Tweets
Magazin
• 18352 Tweets
高校生15人
• 17254 Tweets
激辛ポテトチップス
• 16497 Tweets
東京・大田区
• 15261 Tweets
救急搬送
• 15038 Tweets
アルカディア
• 13421 Tweets
Verbot
• 13389 Tweets
#ViVi国宝級イケメンランキング
• 11759 Tweets
BELLE BLOSSOMS WITH PONDS
• 11456 Tweets
HOLY SMOKES !🤯 You can now auto-create a
#PowerBI
report in Jupyter notebook using pandas dataframe and save it back to service. Below I imported data in Colab, transformed it, updated the autocreated report & saved it back my workspace. The main use case here is interactive EDA
10
80
480
I use Python, DAX, M, SQL every single day and half of my brain power is spent on recalling if that language uses ' ', " ", & or && or and, != Or <> or ~. 🤦
25
44
405
DP-600 (beta) launches on January 11. Sign up now to be among the first certified "Fabric Analytics Engineer Associate".
I am very glad to have played a part in the development of this exam.
11
33
182
I am incredibly grateful to be surrounded by friends and community who support and encourage me 🙏 Thank you
@notaboutthecell
@SimonNuss
@nelliegson
@DataMozart
@VahidDoustiM
@jasehimm
@shan_gsd
Kevin Conan. Special shout out to the
#MicrosoftFabric
PG. Here' to learning,
39
2
179
How insanely AWESOME that with the DAX Query View now you can keep your DAX in draft state, close come back and pick up where you left off, perhaps organize them as well. During development I usually create a page or two for validation, create measures that are used only for
3
16
145
If you are still wondering what is
#SemanticLink
in
#MicrosoftFabric
, check out all my blogs on the topic :
2
12
122
A recruiter reached out to me about a "Power BI" Architect position.
DE + BI +DataViz+SSAS +AAS+SQL+DAX+Python+Spark+ADF+Databricks+RTA (Kafka/Event Hubs)
How many of you will qualify?
30
5
118
9
2
116
Stop everything and read this excellent blog by
@Will_Is_Lucid
on how notebook orchestration in
#MicrosoftFabric
can save in DI costs.
#NotebookEverything
6
14
113
Announcement highlights:
- Fabric goes GA
- Copilots F64+, P SKUs
- Reserved Instances
- Mirroring to take snapshots and save as Delta
- DirectLake on DWH
- RLS/OLS for DirectLake
- Guidelines on DL Fallback (link below)
-🔥🔥Import mode integration in OneLake
-DAX Query view
Exciting start to
#MSIgnite
with
#MicrosoftFabric
"Analytics for the era of AI" becoming GA today. The public preview momentum has been stunning with over 25,000 organizations using Fabric including 67% of the Fortune 500. Blog here: .
#PowerBI
2
82
218
4
25
106
Someone asked me how to get started w/ Python and data analysis in notebooks. I learned from this guy. It's old but it will get you up and running in no time. He covers the Python basics as well, enough for you to do data analysis.
#MicrosoftFabric
1
13
99
Well today is a day of announcements, so here is mine. New blog home: . My first blog post is about the
#DirectLake
datasets. I am still finishing the blog post but thought I would also release a "Public Preview" :D
9
18
99
#MictosoftFabric
Learn Together sessions start Jan 23 where expert led sessions each week (9 sessions) cover Fabric topics to help you prepare for DP-600.
0
22
95
This is cool. Admittedly, I don't use
#DataWrangler
in
#MicrosoftFabric
much because I am good with pandas and know the API well. What I didn't know was I can use it in reverse mode too - write the code and the UI updates itself. This is great for quick feedback without having to
3
13
94
The DAX Query View is almost a notebook like experience with the same shortcuts, command palette etc. Similar to the notebook, folds are created automatically based on indentation but you can create your own folds too to manage the code, especially the long and complex ones. To
3
14
94
If you are new to Python and the
#MicrosoftFabric
notebooks, note that you can type "snippet" in the notebook to access 30+ code snippets pre-written for common tasks.
#NotebookEverything
2
16
89
🔥[New Blog + Python Library] MeasureMaze: Visualizing Measure Dependencies Using Semantic Link & Network Analysis. In my last blog I mentioned that
#SemanticLink
will help create new solutions not possible before, and I meant it - here is an example. I used SL and Network
11
19
90
If you are new to Git, version control, PBIP in
#PowerBI
- highly recommend watching this session by Steve Campbell :
0
17
85
If you are a
#PowerBI
developer and wondering what the
#MicrosoftFabric
Data Science experience has to offer, how to use it to enhance/enrich/augment your reports, what are models/experiments/runs/mlflow etc, please watch my presentation from a couple of weeks ago. A 🧵
1
8
86
[💥New Blog] "Function To Audit Datasources For Query Folding". I wrote a simple M function to get a list of all the queries that are folding or not folding in a
#PowerBI
dataset.
#PowerQueryEverything
5
21
82
✨Super excited to share that I have joined
@HitachiSolUS
as Sr Power BI Architect to help companies create modern data analytics solutions! This makes my foray into consulting so send me all your consulting tips 😁 It's time to broaden the scope and deepen the skills 🚀
19
2
83
There are a TON of innovative features in
@MicrosoftFabric
, so let me give you a quick overview of my favorites that are 🤯 🧵
Really excited to introduce
#MicrosoftFabric
today. A single unified analytics platform, built from the ground up for the era of AI!
Fabric is the next version of
#PowerBI
,
#AzureSynapse
,
#DataFactory
. We are introducing
#OneLake
,
#DataActivator
, and so much more.
Read my
27
427
1K
4
11
81
If you are preparing for DP-600
#MicrosoftFabric
certification, I suggest taking the practice exam (free). It does ask you to log in, I was able to use my M365 Dev account to take the test. Your org account will likely work as well. Good luck 👍
2
16
82
Yayy 🥳 50,000 blog views since I started blogging at a few months ago. Thank you all !
#MicrosoftFabric
4
1
79
For every 10 likes I will add a DAX calculated column 😝
For every 10 likes this gets, I will ask ChatGPT to make this code more insecure
77
527
8K
5
0
76
The goodies just keep coming today..Power BI Jupyter client is now available: .. woohoo!!!
2
20
76
🔥[Blog] Fabric Semantic Link & Use Cases
Here is my blog on why Semantic-Link is one of my top 3 features of
#MicrosoftFabric
and how it's going to change how Data Scientists &
#PowerBI
developers collaborate & unlock new solutions not possible before.
8
17
76
My 8yr old designed experiments, replicated them and visualized them to show which of his Lego car designs is the fastest.
5
1
71
As if
#MicrosoftFabric
notebook wasn't already awesome, it just became 10x awesomer - Easy to browse code snippet library with many useful code snippets in pyspark, scala , R, SparkSQL for common tasks related to visualization, executing notebooks, optimizing delta tables & many
If you are new to Python and the
#MicrosoftFabric
notebooks, note that you can type "snippet" in the notebook to access 30+ code snippets pre-written for common tasks.
#NotebookEverything
2
16
89
3
8
73
Reminder : DON'T publish your private/ company
#PowerBI
reports to web, thinking no one will know. A simple google search can return all publicly available reports.
5
22
70
I scraped the top 1000 ideas from
#MicrosoftFabric
ideas site, analyzed, translated text and created embeddings using Azure OpenAI Cognitive Services (included in Fabric) to do semantic search and clustering using Kmeans and UMAP. You can clearly see the 5 clusters that belong to
6
6
70
Azure Analytics Architecture Advisor has
#MicrosoftFabric
icons as well for creating quick architecture diagrams.
3
14
68
TIL: You can use Ctrl + Shift + L in
#DAX
formula bar for multi-line editing 🤯 Thanks to
@biinsightnz
's blog.
#PowerBI
6
11
68
Blog to come: Visualizing
#PowerBI
measure dependencies in
#MicrosoftFabric
notebook using
#SemanticLink
3
9
65
I have 8 hours to kill at the airport. What better way than renewing all the certifications 😆
4
2
66
💥"Fabric Project 1 : Scraping The Ideas Site". This will be a side project for me to scrape the
#MicrosoftFabric
ideas site and turn it into an end-to-end project that includes using notebooks, pipelines, data science,
#PowerBI
.
2
14
66
Bye
#FabCon
and
#MicrosoftFabric
friends. Fantastic event and organization. Marked 📌Apr 1, 2025 already. My highlights:
- Meeting friends from the community and the product team.
- Learning from the great minds
- SO many telling me they like my blogs and appreciating my
8
0
64
#PowerBI
community is inclusive. We do our best, take care of ourselves & our family. We work hard as anyone else, strive for excellence. We learn, share what we learn & grow. This is not a competition. I am not an MVP but that does not make me any less valuable. Our tent is big!
7
6
64
Shoutout to
@ponderdata
. 60GB csv file with 600M rows in
#MicrosoftFabric
notebook, medium node - querying using pandas API. 50s 🤯 I need to test more, will share the details later.
2
6
59
Deep down in Sept release: Excellent end-to-end tutorial on CI/CD using git + deployment pipelines in
#MicrosoftFabric
. Currently only supports
#PowerBI
items - datasets and reports but I can see other items supported soon.
1
7
62
EVERYONE RUN 🏃🏃🏃 and grab the 80% discount code on
#DP600
beta exam while it lasts. Be sure to use it by Jan 25.
#MicrosoftFabric
9
16
61
6 hours of DAX can save you 5 minutes of star schema
#PowerBI
6 hours of hyperparameter tuning can save you 5 minutes of EDA.
#MachineLearning
#DataScience
3
25
125
5
3
61
Delta lake vs data lake.. you would be surprised how many people confuse the two. If you didn't know, now you know.
Data lake = storage
Delta lake = table format (or MSFT calls it Delta parquet 😁)
2
8
60
Today is my 1st anniversary of when I started blogging and I am celebrating it by giving two back to back presentations. If a year ago you had told me that I will be presenting at
#PowerBISummit
along side some of the experts in
#PowerBI
that I look up to, I'ld have laughed..🧵
5
3
58
Did you know you can comment-out chunk of code in M and DAX by selecting the lines and 'CTRL+/' ? Do the same to remove the comments. Just a reminder. Helps fast debugging.
5
9
57
XTable natively available in
#MicrosoftFabric
, i.e. read Snowflake Iceberg tables as Delta in Fabric shortcuts, without copying or conversion.
#MSBuild
1
9
59
🚨⏱️[Blog] "Refreshing Individual Tables and Partitions With Semantic Link"
#SemanticLink
provides a convenient way to call the Enhanced refresh API to refresh semantic models, tables & partitions in granular details. In this blog, I show how to use it and get the TMSL to check
3
11
56
Ok folks, signing off for the year ! It was a busy and action packed year. I will always remember 2023 as the year of the Fabric! I was totally wrapped in Fabric this year, like many of you 😀 Wish you all happy holidays and happy new year. See you in 2024 🚀
6
0
55
How it *should* go in 2024
The ML, AI & Data Landscape
How it How it’s
started going
(2012) (2024)
27
71
417
3
2
55
The rich dataframes generated with display(..) in
#MicrosoftFabric
notebooks now allow resizing the columns. Thanks
@edelweissno1
#NotebookEverything
1
3
55
Number of great updates to
#PowerBI
in the last one year but the ones that I use the most and have made impact for me:
- Field parameters
- Dynamic formatting
- RLS
- Pause visuals/optimization
- "x" on initial screen (was it this year?)
Any recent features you use a lot/like?
14
6
54
[Blog] 'Accessing Power BI Datasets via XMLA Endpoint in Python Jupyter Notebook'. Here I show how to access the Premium workspace, its datasets and the tables+measures in the datasets. Very handy for data exploration, analysis and ML modeling.
2
15
53
#SemanticLink
v0.6 is out and it is AWESOME!!! Hang tight, blog in coming. You are going to love it and see why it's a must have in your tool chest. Slowly but surely some of the things I mentioned in my first blog are now reality.
#MicrosoftFabric
0
9
54
Interviewer: What's this gap in your resume?
Me: I was waiting for
#PowerBI
dataflow to complete schema validation
Interviewer: What’s this gap in your resume?
Me: Some years ago—never mind how long precisely—having little or no money in my purse, and nothing particular to interest me on shore, I thought I would sail about a little and see the watery part of the world. It is a way I have of
105
3K
34K
3
5
51
🚨New Fabric Runtime 1.2 available now: Spark 3.4, Delta 2.4. pandas has also been upgraded from 1.5 to 2.0.
pandas 2.0 uses the pyarrow backend which significantly improves the performance. Below is a quick test on 9.6M row csv, 4X speedup. It would be great to have polars
4
10
53
This thing confuses me 100% of the times. Why ❌ in red callout if there are no errors
9
1
50
😍😍😍The data preview in the
#MicrosoftFabric
Lakehouse has a PQ-like UI now. You can sort, search, select. Resize column width, select are available but didn't work for me so not sure. I *think* this is based on the 1000 rows just like PQ. Only worked for table, not csv,
3
10
51
The Direct Lake mode in
#MicrosoftFabric
has a fallback behavior. Under certain conditions (memory pressure, # rowgroups, # rows) it will fall to DQ from DL. You can check if the query is in DQ by running Performance Analyzer. DAX studio as well but RO XMLA prevents server traces
4
5
51
Still on the fence about
#DP600
and learning
#MicrosoftFabric
? How about a FREE voucher to take DP600 ? MS Learn AI Skills challenge starts March 19. Complete the challenge get a FREE voucher.
2
15
49
Huge shoutout to
@igocrite
for
#PBIXray
which allows you to access the metadata and data of a
#PowerBI
file in a notebook. He cracks open the internals of pbix to do it instead of connecting to the analysis services which requires you to actually open the file.
#SemanticLink
0
10
49
