Creating cleaner datasets with SQL before connecting Power BI to your database

Hello FFleury_PowerBI,

This looks like a useful approach, especially for users who aren't comfortable writing SQL from scratch.

In my experience, I still recommend reviewing any AI-generated SQL before using it in Power BI, particularly for:

• Join conditions and cardinality

• Filtering logic

• Aggregations and grouping

• Query performance (avoiding unnecessary SELECT * or inefficient joins)

For unfamiliar schemas, having a tool that generates a good starting point can definitely speed up development, but validating the generated SQL against the data model and business requirements is still an important step.

Thanks for sharing - I think this could be a helpful productivity aid for analysts and report developers.

Best regards,
Omkar Shinde
Microsoft Fabric Enthusiast | Power BI Consultant

💡 If you found this response helpful, please consider giving it a Kudos.
✅ If this resolves your question, please mark it as the Accepted Solution to help others in the community.