| title | description | author | ms.author | ms.reviewer | ms.date | ms.topic | ms.search.form |
|---|---|---|---|---|---|---|---|
Create simple reports on your SQL database in Power BI |
Learn how to create simple reports on your SQL database in Power BI |
WilliamDAssafMSFT |
wiassaf |
dlevy |
11/01/2024 |
how-to |
Create Power BI reports using SQL database |
Applies to: [!INCLUDE fabric-sqldb]
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.
- 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.
- 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.
[!div class="nextstepaction"] Share data and manage access to your SQL database in Microsoft Fabric