small data from sql and connect it with bi for generating report

Question

small data from sql and connect it with bi for generating report

Wajahat Ali 0

ok how can i connect sql data base with bi application for generating report

Syed Saleem Peera 13,100 Reputation points Microsoft External Staff Volunteer Moderator

2025-04-18T06:00:09.7666667+00:00

Hello Wajahat Ali,

I wanted to check if you had the opportunity to review the information which was provided in our previous answer. Please feel free to contact us if you have any more quires. If you feel that your quires have been resolved, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post.

Thank you.

1 answer

Your answer

Syed Saleem Peera 13,100 Reputation points Microsoft External Staff Volunteer Moderator

2025-04-18T06:00:09.7666667+00:00

Hello Wajahat Ali,

I wanted to check if you had the opportunity to review the information which was provided in our previous answer. Please feel free to contact us if you have any more quires. If you feel that your quires have been resolved, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post.

Thank you.

Answer 1

Hi Wajahat Ali,

Thank you for reaching out on the Microsoft Q&A forum.

To connect a SQL Server database to Power BI and generate reports, open Power BI Desktop and select “Get Data” from the Home ribbon, then choose “SQL Server” as your data source. Enter the server name and, if applicable, the database name. You can choose between “Import” mode, which loads the data into Power BI for faster performance, or “DirectQuery” mode, which queries the data live from SQL Server. Kindly refer to the screenshot below for guidance. User's image After connecting, you can either select the required tables or write a custom SQL query to pull specific data. Once the data is loaded, you can begin creating your visual reports.

If you are still facing any issue, please let us know in the comments and where you are encountering this error along with the screenshot for reference. We are glad to help you.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

Thank you.

Syed Saleem Peera 13,100 Reputation points Microsoft External Staff Volunteer Moderator

2025-04-16T13:39:55.24+00:00

Hello Wajahat Ali,

Just checking in to see if you had a chance to see the previous answer. Please let me know if it was helpful and don't hesitate to reach out to us if you face any issue.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

Thank you.

Share via

small data from sql and connect it with bi for generating report

1 answer

Your answer