I am currently working on a Power BI project and have encountered a challenge with the Q&A feature. I am a BI developer and could use some assistance in resolving this issue.
My problem revolves around the use of synonyms and the presence of multiple tables with similar column names in my dataset. Specifically, I'm facing errors when trying to utilize synonyms and when referring to columns with similar names across different tables.
I have tried implementing synonyms to enhance the natural language querying experience for our users. However, it seems that the synonyms are not functioning as expected. Additionally, the presence of similar column names across multiple tables is causing confusion and generating errors.
I would greatly appreciate any guidance, tips, or suggestions you may have on how to overcome these challenges. If you could provide me with insights or best practices on effectively utilizing synonyms and handling similar column names, it would be immensely helpful.
Thank you in advance for your time and support. I look forward to hearing from the knowledgeable Power BI community.
Best regards,
Prashant Bisne
