#powerqueryeverything نتائج البحث
#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
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
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
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:
@Rickmaurinus, wouldn't that be nice if all functions would automatically said you their enumerations😁 #PowerQueryEverything
#PowerQuery Maturity Stages Confidently, I’m at 3rd stage. Trying to climb 4th stage proficiently Which stage are you? #PowerBIDev #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_…
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
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
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
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
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
This type of feedback inspires me to create more! #PowerQueryEverything
Godddd 😭 I don't know if I should thank you or fight you for posting this video late. Renaming columns was the most boring part of this project i just completed. Ashey, I could do it at once 🤣
Thank you, I'm sorry. I will be posting more tips now. I do think it's a common thing that people know anytime I do something in Power Query, but now I will try to share more. This type of comment inspires me to create more! #PowerQueryEverything
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
JIRA is not openly available tho and I assure you #PowerQueryEverything When the class is up, you can join to see how #PowerQueryEverything
Okay, I will try it out and get back with update here! Been a while I #PowerQueryEverything 😬 and if I’m stuck, I will run script😂
I’m creating something on that soon! #PowerQueryEverything
#PowerQuery Maturity Stages Confidently, I’m at 3rd stage. Trying to climb 4th stage proficiently Which stage are you? #PowerBIDev #PowerQueryEverything
For the date format inconsistent: if it’s not input error (that is if it’s only the format) #PowerQueryEverything has a function to normalize date to locale format (means it will normalize the date to format you want it to look like irrespective of how it’s been input)
I just finished preprocessing and transformation a data now, and to say #PowerQueryEverything I replicated ROW NUMBER OVER PARTITION in Power Query and converted corresponding rows to column
#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
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
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
For this PowerQuery thingy, forget I be boss 🫡 #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 🏃🏃🏃
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
Trying to get an overview of the Power BI Service I ended up advertising #PowerQueryEverything from @notaboutthecell
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
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
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
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
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
#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
Had a great afternoon talking #PowerBI DAX and #PowerQueryEverything. We recorded the conversation and will be sharing this soon!
Developing #PowerBI Custom connectors is with the new #PowerQuery SDK extension for @code really friendly. #PowerQueryEverything
Isn't that great to be able to execute #DAX in #PowerQuery? Finally, DAX and Power Query can work together. #PowerQueryEverything
Sure. Here is one zoomed in some with a better color scheme (left). Although I prefer to #powerqueryeverything, I also did it with the R visual (pass values from slicers to zoom/explore and let R do the work, using this approach - r-bloggers.com/2014/12/the-ma…).
My favourite new power bi / excel functionality this year. Import dataflows in excel! #powerqueryeverything
#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. #SmackDown 27.4K posts
- 2. George Santos 50.1K posts
- 3. Carson Beck 2,164 posts
- 4. Geno 7,614 posts
- 5. Louisville 10K posts
- 6. Cal Raleigh 4,325 posts
- 7. Ilja 11K posts
- 8. Grand Slam 5,814 posts
- 9. Ohtani 21.1K posts
- 10. Springer 8,616 posts
- 11. Sami 21K posts
- 12. #ALCS 5,204 posts
- 13. Big Dumper 2,345 posts
- 14. Raiola 1,191 posts
- 15. Malachi Toney 1,217 posts
- 16. Dan Wilson 1,550 posts
- 17. #DaytimeEmmys 3,589 posts
- 18. Brendon Little 2,482 posts
- 19. Canzone 3,124 posts
- 20. #askdave N/A