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

[FFleury_PowerBI]

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.

[v-nmadadi-msft]

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.

[v-aatheeque]

Hi @FFleury_PowerBI 

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.

[Omkar_1712 · Accepted solution]

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.