Connect Power Bi Dataflow to a Microsoft SQL Server Database
Hi all, I am trying to connect my Power Bi service directly to a specific SQL Server Database. Precisely, I would like to be able to create a dataflow (in the Power Bi app) that can directly be connected to a SQL server database and thus, pull the data tables of the database into my dataflow. Apparently, even if I use the connection settings and credentials of the database, the connection can not be created ( based on my Session ID). The process I am following is presented below: Go to Power Bi app -> Choose a Workspace - > Crete a new dataflow -> Add new tables -> Choose data source -> SQL Server Database -> Use the credentials of my database -> Result: Unable to create an OAuth connection (for my Session ID) - Europe Notice: I do not have access to the Azure SQL Server, I do only use the Microsoft SQL Server Management Studio Any thoughts and suggestions on that would be appreciated.