#powerqueryeverything search results
#PowerQuery Update: you can now create a full date table in Power Query without writing M code for some columns again. UI make it easier 😌🎉 #PowerQueryEverything #PowerBI #DataTransformation
Did a thing🤩 Just finished scraping 62 pages on a website with #PowerQuery and I need the link in each button for every container. I did extract the underneath link in that button with #PowerQuery This is Superb #PowerQueryEverything 😌😌😌 @MSPowerQuery
40 Days of Fabric: Day 7 Dataflows Gen2 - how to load and transform data with Power Query learn.microsoft.com/en-us/fabric/d… #40DaysOfFabric #PowerBI #PowerQueryEverything
Hybrid Tables can be very useful for mixing archived data with current data. @mahoneypa joins @PatrickDBA to show how to reverse Hybrid within a #PowerBI dataset without Tabular Editor. Just some straight "M"agic. #PowerQueryEverything Watch on YouTube - guyinacu.be/reversehybrid
I could say this about so many #PowerBI sessions at #PowerBISummit but this one from @notaboutthecell and @EscobarMiguel90 is worth the ticket price alone. Heck, the live Q&A for the session was worth the ticket price. So much insight. #PowerQueryEverything
1/7 🧵🔎 Ever been stumped by Enumerations in Power Query M? You're not alone. Let's demystify it together. #BIGorilla #powerquery #powerqueryeverything
Here's how I easily determine data types. The hard way to test for data types: ❌ if Value.Is(Date.From( [MyColumn] ), type date) then "Date" else.... A much easier approach: ✅ if [MyColumn] is date then "Date" else .... #BIGorilla #powerqueryeverything
![Rickmaurinus's tweet image. Here's how I easily determine data types.
The hard way to test for data types:
❌ if Value.Is(Date.From( [MyColumn] ), type date) then "Date" else....
A much easier approach:
✅ if [MyColumn] is date then "Date" else ....
#BIGorilla #powerqueryeverything](https://pbs.twimg.com/media/FtB9iWeWIAUBl2a.png)
#PowerQueryEverything DAX is for analysis expression (business terms) manipulation. It is very powerful, but it has a few concepts that are hard to understand by inductive reasoning. Some functions requires a deductive approach:
#PowerQuery Maturity Stages Confidently, I’m at 3rd stage. Trying to climb 4th stage proficiently Which stage are you? #PowerBIDev #PowerQueryEverything
@Rickmaurinus, wouldn't that be nice if all functions would automatically said you their enumerations😁 #PowerQueryEverything
You can certainly use incremental refresh with #Fabric Dataflow Gen2! learn.microsoft.com/en-us/fabric/d… Periodically revisiting the documentation is crucial, as updates and additions are happening at an incredible pace! #PowerQueryEverything
learn.microsoft.com
Pattern to incrementally amass data with Dataflow Gen2 - Microsoft Fabric
This tutorial takes 15 minutes, and describes how to incrementally amass data into a lakehouse using Dataflow Gen2.
Living in a country with special characters in their alphabet means that native functions are not usable for you, and you must be creative. This can convert JSON to Text and convert letters like "č", "ř", and "á" back from "\u011b" #PowerQuery #PowerQueryEverything
Join @kevarnold and myself as we talk about NO DAX COLUMNS and why they should be cut from #MicrosoftFabric and #PowerBI tomorrow at 7:30 am CDT. #PowerQueryEverything youtube.com/watch?v=oKuO0_…
This weekend, I will have a session on @databash_live about #PowerQuery and custom functions. Would you like to join? Here is a link: databash.live #PowerQueryEverything
Under used and often forgotten option to wrap M in #PowerBI Advanced Editor. Especially helpful when you have a long list of columns selected/removed or SQL statement is used. #PowerQueryEverything
I'm speaking at the biggest online Power BI event of the year, the #PowerBI Summit! My session is about “#PowerQuery (M)agic: Beyond the UI”. Register here: buff.ly/3K4BkE4 #PowerQueryEverything #PowerBI #Excel
Ok... I am a bit lazy... The quickest way for me how to insert data into Werehouse was by direct insert, and yes... I let my Power Query create insert values for me. #PowerQuery #PowerQueryEverything
[💥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 pawarbi.github.io/blog/powerbi/p…
![PawarBI's tweet image. [💥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
pawarbi.github.io/blog/powerbi/p…](https://pbs.twimg.com/media/FdINrFGWIAA4DJw.png)
Still on the way #PowerQueryEverything
So we have Excel, Python, SQL, R, and DAX solutions for this….who’ll run the one for power query? Just bookmark this tweet coz of the day you’ll need to create date-table for a project 🏃🏃🏃
40 Days of Fabric: Day 7 Dataflows Gen2 - how to load and transform data with Power Query learn.microsoft.com/en-us/fabric/d… #40DaysOfFabric #PowerBI #PowerQueryEverything
Trying to get an overview of the Power BI Service I ended up advertising #PowerQueryEverything from @notaboutthecell
Hybrid Tables can be very useful for mixing archived data with current data. @mahoneypa joins @PatrickDBA to show how to reverse Hybrid within a #PowerBI dataset without Tabular Editor. Just some straight "M"agic. #PowerQueryEverything Watch on YouTube - guyinacu.be/reversehybrid
1/7 🧵🔎 Ever been stumped by Enumerations in Power Query M? You're not alone. Let's demystify it together. #BIGorilla #powerquery #powerqueryeverything
Here's how I easily determine data types. The hard way to test for data types: ❌ if Value.Is(Date.From( [MyColumn] ), type date) then "Date" else.... A much easier approach: ✅ if [MyColumn] is date then "Date" else .... #BIGorilla #powerqueryeverything
New Episode 🎧 Miguel Escobar of "M is for data monkey" fame and its recent completely re-written version "Master Your Data" Now a Product Manager at Microsoft aiming to #PowerQueryEverything The one with @EscobarMiguel90 Links⏬ #PowerQuery
Thanks to everyone who tried to use the M Code I shared from my WhatsApp Analysis. I got feedback from a few folks on when the function didn't work for their data. So I learnt a few more things and updated it to be a bit more dynamic and easy to use. #PowerQueryEverything
Why do things the easier way you can do it the more complicated way? #PowerQuery #PowerQueryEverything @MSPowerQuery
I could say this about so many #PowerBI sessions at #PowerBISummit but this one from @notaboutthecell and @EscobarMiguel90 is worth the ticket price alone. Heck, the live Q&A for the session was worth the ticket price. So much insight. #PowerQueryEverything
Had a great afternoon talking #PowerBI DAX and #PowerQueryEverything. We recorded the conversation and will be sharing this soon!
#PowerQuery Update: you can now create a full date table in Power Query without writing M code for some columns again. UI make it easier 😌🎉 #PowerQueryEverything #PowerBI #DataTransformation
Developing #PowerBI Custom connectors is with the new #PowerQuery SDK extension for @code really friendly. #PowerQueryEverything
My favourite new power bi / excel functionality this year. Import dataflows in excel! #powerqueryeverything
Isn't that great to be able to execute #DAX in #PowerQuery? Finally, DAX and Power Query can work together. #PowerQueryEverything
Join @kevarnold and myself as we talk about NO DAX COLUMNS and why they should be cut from #MicrosoftFabric and #PowerBI tomorrow at 7:30 am CDT. #PowerQueryEverything youtube.com/watch?v=oKuO0_…
#PowerQueryEverything DAX is for analysis expression (business terms) manipulation. It is very powerful, but it has a few concepts that are hard to understand by inductive reasoning. Some functions requires a deductive approach:
Something went wrong.
Something went wrong.
United States Trends
- 1. Marshawn Kneeland 2,418 posts
- 2. Nancy Pelosi 11.7K posts
- 3. #MichaelMovie 14.1K posts
- 4. ESPN Bet 1,655 posts
- 5. Good Thursday 32.5K posts
- 6. Gremlins 3 1,515 posts
- 7. #thursdayvibes 2,567 posts
- 8. Madam Speaker N/A
- 9. Happy Friday Eve N/A
- 10. Joe Dante N/A
- 11. Jaafar 3,960 posts
- 12. Penn 8,975 posts
- 13. #ThursdayThoughts 1,723 posts
- 14. Chris Columbus 1,408 posts
- 15. Chimecho 2,510 posts
- 16. Korrina 2,133 posts
- 17. Baxcalibur 2,049 posts
- 18. #thursdaymotivation 1,625 posts
- 19. Barstool 1,458 posts
- 20. #LosdeSiemprePorelNO N/A