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.
Unable to Connect we encountered an error while trying to connect with Microsoft SQL
Hello Guys, while i am trying to connect to SQL Server, it was showing some error message. The content of the error message can be found below in bold.. Details: "Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)" For reference please check with the screenshot of the error message which was attached to this post or message.. Kindly put down the solution(s) in step by step manner as it would be helpful to me and the PBI community as well...
