No more 999+ rows in Power Query | How to get the exact row count in Power BI
#learnatcloudanalytics
#powerbi
No more 999+ rows in Power Query | How to get the exact row count in Power BI
Note: Do not hit on this URL 👉https://bit.ly/3ArlahQ
This video helps you get the exact number of rows in a table in Power Query editor using the column profile option.
By default, the Power query editor displays the top 1000 rows based profiling and if we wanted to change it to based on entire dataset then we would need to change this from the taskbar on the Power Query editor and enable the column profile option from View ribbon.
-------------------------------------------------------------------------------------------------------------------------------------
Learn How to become a Power BI developer 👉
This Complete Power BI Tutorial takes you Step-by-Step as you use Power BI Desktop to create a beautiful Power BI Dashboard. 👉
✅ Subscribe to always get my latest videos: / @learnatcloudanalytics
▶️Topics Covered in this playlist includes◀️
1. Get Data (Query Editor)
2. Relationships
3. DAX
4. Visuals
5. PowerBI.com
6. How to become a Power BI developer
7. Roles and responsibilities of a Power BI developer
8. DAX functions
9. Data modeling
10. Reporting tips & tricks
11. Power BI features
----------------------------------------------------------------------------------------------------------------------------------------
For videos on DAX functions 👉
1. What is DAX: • What is DAX and its importance in Pow...
2. SUM vs SUMX : • SUM vs SUMX in Power BI | DAX tutoria...
3. SAMEPERIODLASTYEAR : • How to create SAMEPERIODLASTYEAR in P...
4. PARALLELPERIOD: • How to create PARALLELPERIOD in Power...
5. Calculate DAYS In YTD: • Calculate days in YTD | Power BI Date...
6. YTD | QTD | MTD : • How to Calculate YTD, QTD, MTD in Pow...
7. TOPN : • TOPN DAX in Power BI | Power BI Inter...
8. RANKX : • RANKX in Power BI | How can we overco...
⚡Happy learning - Power On!⚡
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► / sailaja-chintala
Twitter ► @chintalasailaja
Gmail ► [email protected]