Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Reply
MarcelB
New Member

Published report with DocumentDB query refresh data problem

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.

0 REPLIES 0

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.