Connect SQL SERVER to POWER BI [AdventureWorks2020 Sample Database] 🔗

[@AnkitaB-hz5vk]

After so much of struggle, finally found this amazing video.This is what I was looking for. Thank you for sharing this video!!!!

[@NestorAdrianzen]

Glad it helped!

[@Bets-g8f]

Dear Nestor, it helped me lot in a short time, I am very happy about your explanation.

[@NestorAdrianzen]

Glad to hear that. Thanks for your support👍

[@mohamedfouad7958]

Thanks a lot for your efforts. You helped me to do the connection in short time.

[@NestorAdrianzen]

Glad it helped. Cheers!

[@ajinkyashinde1778]

This is what you can call a real-life example. not just csv and excel sheet demo in all power bi video. really helpful.
can you please upload the data gateway and data flow example for power bi service as well. so, it's better to understand how to connect data like this in real life like this video. not just csv and excel file demo

[@NestorAdrianzen]

@ajinkyashinde1778, Thanks for stopping by. The data link should be here: drive.google.com/file/d/1yiYMCzvtE7Ez1zm7OInftdFswmPw1xJB/view

[@navjotsingh2251]

Really great video. Would love to see more videos about power BI and SQL from you. You are the best for this 😭😁

[@NestorAdrianzen]

Glad to Herat that. Cheers!

[@alexrosen8762]

Super useful demo and great explanation!

[@NestorAdrianzen]

Thanks for stopping by, Alex! Keep it 🆙

[@manggnorora]

Thank you for this sir!

[@NestorAdrianzen]

God you found the content helpful. Cheers

[@dillonbarclay8373]

Thank you!

[@NestorAdrianzen]

Glad you found the content helpful. Cheers 👍

[@gordan258]

Hi Nestor, thanks for the video. Could you please advise : what is the best way to standardize accounts used for sql server connection when we have multiple databases on the same sql server, multiple Power Bi rapports on each of the database and multiple users who need to connect different data/databases? Do you see any strategy to apply? Also, what exactly is the role of the report publishing account? Is this the service account that runs the report only for all the users that have access to see the raport? Thanks kindly to gide us to the right direction.

[@NestorAdrianzen]

Gordan, Thanks for stopping by. If you have multiple databases and reports, you might want to consolidate them in just a Power BI app. Then create distribution groups within that Power BI app. By doing so you will give access to those reports to specific end-users only.
In order to create Power BI apps, you need to have at least a Power BI Pro license. I hope that helps!

[@akshaynikam6628]

It's fantastic video..!

[@NestorAdrianzen]

Thanks for your support, Akshay! Cheers!

[@litefeather1123]

Thank you for the great video. I have a question, can you do this using Power BI free license or do you need pro or premium?

[@NestorAdrianzen]

Thanks for stopping by, Litefeather!
To connect Power BI Desktop with SQL Server, you don't need a Power BI license. Also, SQL Server Management Studio is a free version. However, if you want to publish your reports to Power BI service (Cloud), you do need a license (Pro or Premium). I hope that helps!

[@litefeather1123]

@@NestorAdrianzen Yes this helped, thank you for the reply!

[@taraprasaddash8643]

Excellent video

[@NestorAdrianzen]

Glad you found it helpful! Cheers!

[@humberto8462]

Fantastic

[@NestorAdrianzen]

Humberto,
Glad you found the content helpful. Saludos 👍

[@afonsoosorio2099]

Awesome

[@NestorAdrianzen]

Thanks for stopping by. Cheers 👍

[@bzflowerbee]

How did I miss this?

[@NestorAdrianzen]

bzflowerbee, It happens 😃 Thanks for your support!

[@Confort-Kid-Autism]

Merci pour votre effort. Toujours vous êtes excellent.

[@NestorAdrianzen]

Je suis toujours heureux d'aider!