top of page
Vojtěch Šíma | The Data Bender
Vojtěch Šíma | The Data Bender


Native write-back in Power BI (Fabric preview)
Power BI just got an upgrade. With User Data Functions and Translytical Flow Tasks in Microsoft Fabric, you can now write comments or updates directly to your SQL tables — straight from a report. No extra tools, no clunky workarounds. This guide walks you through building your first real-time write-back feature step by step.
Vojtěch Šíma
Jun 137 min read
27 views
0 comments


While Loop in M Language
While loop in M Language using List.Generate()
Vojtěch Šíma
May 137 min read
20 views
1 comment


Refresh Semantic Models Every Minute – Now in Fabric (Preview)
Refresh Semantic Model every minute in Fabric
Vojtěch Šíma
May 53 min read
25 views
0 comments


Make Your Power Query Dynamic with Parameters
Make your Power Query Dynamic with Parameters, examples like: synced date filter on queries, filter the same list of values, etc.
Vojtěch Šíma
Mar 2310 min read
163 views
0 comments


Top everyday DAX functions
tl;dr DAX has probably hundreds of functions, however, several of them stand out. You will probably use them in every project. Normally I...
Vojtěch Šíma
Feb 1814 min read
28 views
0 comments


Ultimate intro to Power Query M Language
tl;dr "M" is a language used in Power Query to transform, filter, and combine data. Power Query automatically generates M code based on...
Vojtěch Šíma
Feb 714 min read
112 views
0 comments


Combine Files Quickly in Power Query
tl;dr Power Query provides a native file combiner, but it can feel complex and generates numerous queries. In this article, you'll learn...
Vojtěch Šíma
Dec 22, 20248 min read
75 views
0 comments


API Authentication in Power Query
tl;dr when working with APIs in Power Query, we use couple of authentication methods: Anonymous, API Key, Bearer Token, Basic, OAuth 2.0....
Vojtěch Šíma
Nov 25, 20249 min read
292 views
0 comments


Pagination in Power Query
tl;dr pagination is a form of dividing data into smaller chunks (pages). With this method we can achieve more efficient transfer of data....
Vojtěch Šíma
Nov 13, 202410 min read
190 views
0 comments
bottom of page