Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Situation: I have two tables both containing different data regarding 3 Identity columns.
I have merged them and formatted the result to my liking then applied the resulting table.
When I then view this new merged table via the data tab it shows more rows that what were shown in the query editor, these additional rows dont have the formatting that I had applied but do seem to be related to one or other of the original tables.
Is there anyway I can see these additional rows or ensure that they pick up the formatting that I need for my visuals to work?
As of now there is a maximum number of cells that can be displayed in the queries editor. We are working to lift this restrictions in the future.
Fow now, you have a few workarounds as options:
1. You can use the queries editor side by side to the data grid. If you see the anomaly in the data view, you can formalize a plan to fix them and then apply the fix in the queries editor.
2. You can skip top x rows in the queries editor by clicking on the table menu on the top left corner of the table. This generates a step which you can later delete when you are done.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
71 | |
38 | |
28 | |
26 |
User | Count |
---|---|
99 | |
88 | |
62 | |
42 | |
39 |