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.
Hello all,
Any have or seen this issue? We have a financials dataset that refreshes every two hours. Twice now I have been alerted by the users that the values seem to twice as high as they should. I look at the source tables in the database and everything looks fine, I manually refresh the dataset in the service and the values go back to "normal".
Seems that the refresh doesn't always dump the old data. Any ideas on what could be going on, how to verify/troubleshoot, or thoughts on how to monitor/prevent?
Thank you
Anyone else experience this?
My users are still seeing this. About ready to open a ticket, but hesitate as the issue is difficult to demonstrate/replicate.
Hi @Aron_Moore. Thanks for reporting this. I'd recommend you do the following:
Ehren
Thanks Ehren.
Hi @Aron_Moore,
A few questions to get a better grasp of the issue:
1. How many rows are being retrieved? How many of those are duplicate?
2. Does this happen within a particular range or rows? (i.e. if you retrieve 50,000 rows, does the duplication only occur within a certain range, like 0-4000?).
3. Is the data sorted in any way? If so, it it sorted by a key?
4. Does this happen when retrieving rows from a single query or just when combining multiple queries?
Jorge
Thanks @jjgb
1. How many rows are being retrieved? How many of those are duplicate?
2. Does this happen within a particular range or rows? (i.e. if you retrieve 50,000 rows, does the duplication only occur within a certain range, like 0-4000?).
3. Is the data sorted in any way? If so, it it sorted by a key?
4. Does this happen when retrieving rows from a single query or just when combining multiple queries?
Hi @Aron_Moore,
"Twice now I have been alerted by the users that the values seem to twice as high as they should." What do you mean of this sentence? You got an alert/error message said that? Please share more details.
Thanks,
Angelia
No errors or alerts really.
Say the users know they've entered around 100 purchase orders over the period with a total revenue of $100 million, but when they use the dataset from the service it shows 200 and $200. They know that's not right, so they reach out to me. I refresh the dataset manually and it gets resolved.
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.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |