Optimising The Performance Of Power Query Merges In Power BI, Part 3: Table.Join And SortMerge from
In the last two posts in this series I showed how removing columns from the tables used in a Power Query merge operation can improve...
top of page
Tips and news from all over the web
The Microsoft Power Platform Blog
Search
Reviewed by Maslows
- Jun 7, 2020
- 6 min
COVID-19 dashboard in Power BI: Running Averages from DataChant
Follow @gilra In my last tutorial here, you learned how to apply a What-If technique to calculate the estimated active cases of COVID-19....
00
Reviewed by Maslows
- Jun 3, 2020
- 3 min
Optimising The Performance Of Power Query Merges In Power BI, Part 2: Does When You Remove Columns M
In my last post I demonstrated how the size of a table affects the performance of Power Query merge operations on non-foldable data...
10
Reviewed by Maslows
- May 18, 2020
- 3 min
Performance tip to speed up slow pivot operations in Power Query and Power BI from Power BI – The BI
Pivot operations in are a very handy feature in Power Query but they can slow down refresh performance. So with some bittersweet...
00
Reviewed by Maslows
- May 15, 2020
- 2 min
How not to miss the last page when paging with Power BI and Power Query from Power BI – The BIccount
When you use an API with a paging mechanism (like the example from this blogpost), you’ll might work with a field that contains the...
00
Reviewed by Maslows
- May 12, 2020
- 1 min
FastTrack Recognized Solution Architect from DataChant
Follow @gilra In case you watched the MBAS virtual summit sessions, you might saw me in minute 11:11 of the keynote session here. I was...
00
Reviewed by Maslows
- May 11, 2020
- 4 min
#PowerBI Bookmarks vs Page Navigation from Prathy’s Blog…
Power BI Bookmarks, the secret behind many sleek reports, It revolutionised the entire PBI Report design approach. Initially, Bookmarks...
80
Reviewed by Maslows
- May 4, 2020
- 5 min
COVID-19 dashboard in Power BI: What-If from DataChant
Follow @gilra In my last tutorial here, you learned how to apply basic time intelligence in Power BI to build your own COVID-19 dashboard...
00
Reviewed by Maslows
- May 2, 2020
- 1 min
Automatically detect and change the types of all columns at once in Power Query from Power BI – The
Today I want to share quick tip on how to automatically detect and change all column types at once in Power Query. Background Very often,...
00
bottom of page