Top Tweets for #PowerQuery
Have you ever wanted to add your favourite icons to the QAT (Quick Access Toolbar) in the #PowerQuery editor in #Excel or #PowerBI? Wonder no more! In this video, I'll show you how I added the "Detect Data Types" button to the Power Query QAT. 🛠
https://t.co/jgLMqiOyK2
Have you ever wanted to add your favourite icons to the QAT (Quick Access Toolbar) in the #PowerQuery editor in #Excel or #PowerBI? Wonder no more! In this video, @kpuls will show you how he added the "Detect Data Types" button to the Power Query QAT. 🛠
https://t.co/ssRw5xnQSi
The QuerySleuth feature of our Monkey Tools #Excel Add-in is a must-have for every #PowerQuery user. It automatically indents and wraps your M code, and highlights the syntax by colour. 🤓 (However, you can adjust these options as you prefer.)
Learn more: https://t.co/U8iNTzmeBs
Query folding is greyed out — and your incremental refresh is loading every row on every run. 🛑📊 No error. No warning. Just "success" in the history log.
https://t.co/lUaffsclie
#AIBuzz #PowerBI #QueryFolding #IncrementalRefresh #PowerQuery
Data cleaning is one of the most important parts of any Power BI project.
If you clean the same kind of messy data again and again, you’ve probably wished there was a function for it.
You can make that function yourself in #PowerQuery, and it’s simpler than it looks.
Open the Advanced Editor and write three things:
1️⃣ The inputs, like (a, b)
2️⃣ The rocket sign =>
3️⃣ What it should do with the inputs
That’s a custom function. Use it in any query in one line. And with AI, it’s easier than ever to create custom functions. Just test what it writes before you use it.
See how it works below 👇
If this helped, follow me and repost it so your network sees it too ♻️
P.S. I’ve shown how to use it on a real data cleaning problem. Check the comments.
#PowerBI #DataCleaning #DataAnalysis
見た���が整った表でも、集計しやすいとは限りませんね。Power QueryやAIを使う前のデータ整備にも注目です。業務改善ラボもぜひチェックしてくださいね。
#Excel #PowerQuery #業務改善ラボ
Your manager sends 14 Excel reports and wants them combined in 30 mins.
Don’t copy and paste.
Data › Get Data › From Folder › Combine & Transform.
New report tomorrow? Drop it in the folder and click Refresh All.
Set it up once, reuse it forever. 🧵
#Excel #PowerQuery
Learn how to load CSV files from the web into #Excel using #PowerQuery. 🌐 In this new video, @kpuls shows 2 ways:
🟩Using the specific From Text/CSV connector, or
🟩Using the more general From Web connector.
Plus, you can then refresh with a single click!
https://t.co/ctLy66SHnd
I love teaching in person! 💕 I'm leading my 3-day #SelfServiceBI Boot Camp as part of Bulgaria Excel Days. One of the 1st things covered today was the #BusinessIntelligence ecosystem and how we can use #Excel, #PowerQuery, #DAX, and #PowerBI together for robust reports.
本日、Excel Power Queryの書籍が発売になりました❗
普段の業務でExcelを使っていて、
「毎回同じデータ加工をしている」
「複数ファイルの集計が大変」
という方に、ぜひ活用していただければ嬉しいです😊
https://t.co/2dSEh9nAt0
#Excel #PowerQuery #業務改善
パワークエリの「代替行の削除（Table.AlternateRows）」って機能、名前が直訳過ぎて分かりにくいんですよね
「隔行の抜き出し」とか「一定間隔の行」とか、もうちょっとましな名前にできないもんでしょうか
#Excel #PowerQuery
#PowerQuery allows you to master you data in #PowerBI and #Excel, so you can automate your #DataCleaning 🧹 and #BusinessIntelligence processes.💪 Join the ultimate Power Query course today at https://t.co/lP4gEAqb5r
#DataTransformation #DataAnalyticsTraining #FinancialAnalysis
#PowerQuery でステップ名を全部変更する派だけど、フォルダごと取込でヘルパークエリ生成されたときに自動生成されたステップは図のように、「↓ここから自動↓」とか空ステップを挿入するようにしている
#Excel
月次CSVの結合、まずは完成例で練習。
500円で「練習CSV＋完成Excel＋解説」を用意しました。翌月追加・エラー復旧・検算から、Mコードの読み解きまで。
Windows版Microsoft 365 Excel向けの初級教材です。
https://t.co/KKNrhs2iIr
#便利工房ラボ #PowerQuery #業務効率化
こういう単票データのテーブル化、#PowerQuery や #ExcelVBA を使って、幾度となく対応してきました😊
美しさがあるならば、きっと規則性があって、規則性があるならば、機械的にデータを抽出する余地はきっとあるはず✨
#Excel
データを集計・分析するための表計算ソフトを、セルを10ピクセル四方の正方形に縮小し、「美しい印刷用フォーマット」を作るためだけに駆使するベテラン社員。セルの結合と神がかったレイアウト調整によって作られたその芸術作品は、機械によるデータの自動抽出（CSV化）を一切寄せ付けない、最強のデジタル防壁として君臨している。
Yesterday we shared a video on how to compare values based on the prior row's data. This #PowerQuery recipe card outlines the steps that @kpuls demonstrated. 👩🍳Get the full Power Query Recipe collection at https://t.co/EQYEQyeXPk
#Excel #PowerBI #DataAnalytics #DataPreparation
#PowerQuery doesn't have a great concept of row context, making it very difficult to compare values across rows. 🔢 In this Monkey Shorts, I demo a super-cool black magic technique that allows you to do exactly that. 😈 https://t.co/n2d6qw2sGN
#Excel #PowerBI #DataAnalytics
Comparing two Excel lists? Use Power Query Merge:
Inner = items in both
Left Anti = only in list 1
Right Anti = only in list 2
Load each list as a connection, choose the join kind, then refresh next month. No copy/paste detective work.
#Excel #PowerQuery
MASTER POWER BI WITH JOB READY DATA ANALYTICS SKILLS
Starting: 24 October 2026
Saturday & Sunday |1:00 PM 3:00 PM
Register here https://t.co/mxGuko2Z8V
+92 326 6302000
#PowerBI #DataAnalytics #PL300 #MicrosoftPowerBI #BusinessIntelligence #PowerQuery #DAX #LogixDive #ITTraining
毎朝8時に、MotionBoardの明細表���ら前日分のデータを検索、CSVファイルで指定フォルダにダウンロード、そのフォルダを参照したPowerQueryで更新といった作業を行ってます。自動更新をするにはPower Automateでも出来るかな？
#なみおのExcel改善日記
#PowerAutomate
#PowerQuery
#MotionBoard
Last Seen Hashtags on Sotwe
shota() +filter:native_video
Seen from Philippines
Granny()
Seen from Algeria
Chinadrama
Seen from Indonesia
GoalOfTheDay
Seen from Japan
blowjob #hijab
Seen from Turkey
konyasahibe
Seen from Turkey
anal #orgasm
Seen from Australia
melekazad
Seen from Switzerland
snapchat
Seen from Canada
infiel #anal
Seen from Algeria
Most Popular Users
Elon Musk 
@elonmusk
241.5M followers
Barack Obama
@barackobama
118.8M followers
Cristiano Ronaldo
@cristiano
114.5M followers
Donald J. Trump
@realdonaldtrump
111.8M followers
Narendra Modi
@narendramodi
107.1M followers
Rihanna
@rihanna
98.7M followers
NASA
@nasa
92.3M followers
Justin Bieber
@justinbieber
91.8M followers
KATY PERRY
@katyperry
90M followers
Taylor Swift
@taylorswift13
84M followers
Lady Gaga
@ladygaga
75.5M followers
Virat Kohli
@imvkohli
73.5M followers
Kim Kardashian
@kimkardashian
70.9M followers
YouTube
@youtube
68.8M followers
Neymar Jr
@neymarjr
66.5M followers
Bill Gates
@billgates
65.3M followers
Selena Gomez
@selenagomez
63.1M followers
The Ellen Show
@theellenshow
62.2M followers
CNN
@cnn
61.7M followers
X
@x
60.7M followers