Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
In Power BI Desktop I created a report with a DocumentDB query. On the report a card is displayed with the number of records.
After publishing the report on powerbi.com I get the same number of records as Power BI Desktop, all good. But when the dataset on app.powerbi.com is refreshed (manually or scheduled) the number of records is half of what I expected. After a second refresh the number of records is 1 or 0.
The DocumentDB database is using partitioned collection. As a test, when I specify a specific partitioned collection in the query source, it makes no difference. After refreshing the dataset on app.powerbi.com, only a part of the records or no records are displayed.
I also tested it with and without expanding the document, same problem.
Any idea how to solve this problem? Thanks.
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 16 | |
| 14 | |
| 13 | |
| 8 | |
| 7 |
| User | Count |
|---|---|
| 41 | |
| 40 | |
| 34 | |
| 28 | |
| 24 |