Jan 26 2022 09:30 AM
Jan 26 2022 11:50 AM
Jan 26 2022 02:01 PM
Jan 29 2022 02:44 AM
Screenshots above are from Power Query editor.
Jan 29 2022 03:02 AM
Jan 29 2022 03:31 AM
Oliver, Power BI Desktop Data view is actually shows you data model table. That's not Power Query. If in Excel you open data model with Power Pivot it also shows full number of records.
Jan 29 2022 02:14 PM
Jan 30 2022 06:15 AM
So, we speak about Power Query editor, not about difference between Excel and Power BI Desktop. If Power Query doesn't load result to data model (e.g. connection only mode) in both we have only Power Query editor to check. If we load to data model, in both we may work further with data model, the only entry points are different.
For both in Power Query editor we may see number of values in the column if shift column profiling base from first 1000 rows on entire data set rows and keep active Column Profile in View tab. That is actually number of rows.
If by default evaluate preview based on entire data set performance could be decreased dramatically. Both for Power BI Desktop and Excel, doesn't matter.