Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.