Create simple reports on your SQL database in Power BI
Applies to: ✅ SQL database in Microsoft Fabric
It's easy to quickly create reports with SQL database in Fabric. In this walkthrough, we walk through the steps to define a semantic model and build a report.
Prerequisites
- You need an existing Fabric capacity. If you don't, start a Fabric trial.
- Make sure that you Enable SQL database in Fabric using Admin Portal tenant settings.
- Create a new workspace or use an existing Fabric workspace.
- Create a new SQL database with the AdventureWorks sample data.
Build a new report
- Once the sample data is loaded, switch over to the SQL analytics endpoint via the dropdown menu in the Query editor.
- Select the Reporting menu from the ribbon, then New Report.
- Choose Continue to create a new report with all available data.
- Once Power BI opens:
- Create a new report by dragging data into the report.
- There's also the option to use Copilot. That is what we use for this tutorial. Select the Copilot button in the toolbar.
- Copilot presents some reporting suggestions. Select Suggest content for a new report page.
- Review the selections by expanding their cards. Select Create on any and all suggestions that look interesting. A new tab is created at the bottom for each.
- You now have a Power BI report of your SQL database data. Review the reports for accuracy and make any desired modifications.