Forum Discussion
Creating cleaner datasets with SQL before connecting Power BI to your database
Hi everyone,
I made a short walkthrough showing how Power BI users can write SQL statements using plain English to help prepare cleaner datasets before connecting Power BI to a database.
Walkthrough:
https://www.sqlmocker.com/use-cases/power-bi-sql-generator
I’d be interested to hear how Power BI users currently review SQL before connecting to a database, especially when working with unfamiliar schemas or wide tables.
Any feedback on the workflow would be welcome.
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.
3 Replies
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.Hi FFleury_PowerBI ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.Thank you.
We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.
