Forum Discussion
Prep Data for AI increasing dataset size and truncating all responses?
Indeed, both datasets are uploaded in service and both use incremental refresh. I haven't checked the indexed queries, I'll have a look now, thanks.
Do you think the issue could be in the metadata? Since I changed measure names to be more legible (i.e. "cnx bkg this" to "cancelled bookings CY") and added descriptions and synonims that were not there before, could that increase in metadata characters be causing the issue?
Super UserI don't think so. According to docs and Webb posts only actual data affects indexing not metadata.
you have more than 5MLN distinct text values in your dataset haven't you?
Webb also said that copilots may think to have to scan +5MLN rows.
adding more clarity with AI instructions may trigger copilot to know he has to scan +5MLN rows and if data you're requests are outside the boundaries scanned it simply say "nothing to show".
unfortunately I'm just guessing and I think you should fire a ticket to microsoft.
Thanks, will probably do that.
I understand the 5M limitation and yes, probably over that, but I keep wondering why the original one with the same data returns correct values and doesn't trigger the issue while the copy does. For example if I ask 'Average lead time for Europe for May 2026', on the original dataset I get the correct value (checked myself in connecting to the dataset to do a report) and the prepped dataset returns incorrect values (because of the warning).I'll open a ticket, thanks a lot for your help.
- v-menakakota
Community Support
Hi tdponcelas ,
Thank you for reaching out to the Microsoft Community Forum.You already isolated most of the obvious variables here. So, at this stage opening a Microsoft Support ticket, is probably the right move. Include screenshots/examples of prompts that return correct values in the original dataset but fail in the prepped one, because that comparison is probably the strongest evidence that this is an indexing or Copilot interpretation issue rather than a model size issue.
Below is the link to help create Microsoft Support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft LearnIf I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Community Support Team- v-menakakota
Hi tdponcelas ,
I hope the above details help you fix the issue. Could you please confirm if the issue has been resolved after raising a support case? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.
Thank you for your understanding and assistance.
Best Regards,
Community Support Team.