Skip to main content
Microsoft Idea

Power BI

Needs Votes

Running R Transform script in SQL Server Execution Context in PowerBI

Vote (1) Share
Krati Singh's profile image

Krati Singh on 30 Jan 2017 16:16:18

Is there a PowerBI sample available with R transform script running in SQL Server execution context? I am getting following error: Error in .rxEnsureOdbcCredentials(connectionString, server, databaseName, :
Trusted_Connection or User must be specified either in the connection string with the uid keyword or as a named parameter.
Calls: rxSetComputeContext ... initialize -> initialize -> .local -> .rxEnsureOdbcCredentials
Execution halted
Please suggest.