Город МОСКОВСКИЙ
00:03:59

How to LIMIT ROWS Dynamically in Power Query | Power BI

Аватар
Эксель Шаг За Шагом
Просмотры:
27
Дата загрузки:
06.12.2023 01:21
Длительность:
00:03:59
Категория:
Технологии и интернет

Описание

In this video, I have solved the users' problem they face while developing a Power BI report when they have huge data i.e. Millions or Billions of rows in a table by restricting the rows dynamically in Power query with a condition. So that they can directly do the Full data load in Power BI Service instead by editing the parameter value to 0.

Learn Power BI through my other Videos :

1.Complete Power BI Project 2023 - Sales Dashboard: https://www.youtube.com/watch?v=SbbkNdpn8Jw&t=63s
2.End to End Power BI Project in 40 min: https://www.youtube.com/watch?v=SLRpk9MD1ys&t=983s
3.Create dynamic charts with TOP N : https://www.youtube.com/watch?v=xT9CLKNL-7c&t=7s
4.How to Join Two Tables with Multiple columns in Power BI: https://www.youtube.com/watch?v=j-RBZQbWQOM
5.How to Create a Date Table in Power Query: https://www.youtube.com/watch?v=LpsfIgC4mX4&t=158s
6.How to Create a Date Hierarchy in Power BI: https://www.youtube.com/watch?v=xnWZrIV_g9s
7.How to Create Bookmark with a Slicer in Power BI: https://www.youtube.com/watch?v=4de5dqZRXzc&t=77s
8.End to End Power BI Project using NLP in 15 min: https://www.youtube.com/watch?v=0Chyi4i0aXk&t=25s
9.DISTINCT vs VALUES: https://www.youtube.com/watch?v=0Chyi4i0aXk&t=25s
10.Generate Dates between Start Date and End Date in Power BI : https://www.youtube.com/watch?v=0V-RLqf1DWU&t=168s

#powerbi #powerquery #tutorial

Рекомендуемые видео