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
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.
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!
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!
![Connect SQL SERVER to POWER BI [AdventureWorks2020 Sample Database] 🔗](/img/logo.svg){kind=logo}
