This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
I count the number of rows in Power Query and it's 4836 rows. Then I apply and close the power query and publish the report to PBI service. I then export the data both in xlsx and csv and I get 4212 rows. When I build a dashboard it's still 4836 count. Seems like it's only happening when I export data. I tried different ways but it's not exporting all rows. Does anyone face the same issue?
Solved! Go to Solution.
Hi @Anonymous ,
Please try creating a new index column in Power Query and try exporting again.
I have encountered the same problem before and it was caused by duplicate columns.
refer:
Best Regards
Lucien
Hi @Anonymous ,
Please try creating a new index column in Power Query and try exporting again.
I have encountered the same problem before and it was caused by duplicate columns.
refer:
Best Regards
Lucien
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 10 | |
| 10 | |
| 7 | |
| 6 | |
| 5 |
| User | Count |
|---|---|
| 24 | |
| 23 | |
| 22 | |
| 21 | |
| 20 |