cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
davidmitrovic
‎06-16-2023
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Connection string to use PowerBI with SAS

by Calcite | Level 5 in Administration and Deployment
‎02-16-2022 03:28 AM
‎02-16-2022 03:28 AM
It is a solution but in this server we have already defined 8 different SASApp. Our idea is to define the connection string so that we can specify a single library to connect to. 😞 ... View more

Re: Connection string to use PowerBI with SAS

by Calcite | Level 5 in Administration and Deployment
‎02-15-2022 06:09 PM
‎02-15-2022 06:09 PM
Hi, The problem is not with the libraries, is with the information that returns the OLE DB connection from PowerBI. The connection returns for example, the following libraries (and all the tables that the libraries contains):   Lib1 Lib2 Lib3 But with the PowerBi we only wants to see the library "Lib3" with the tables of that library only.   Thanks! ... View more

Connection string to use PowerBI with SAS

by Calcite | Level 5 in Administration and Deployment
‎02-15-2022 11:45 AM
‎02-15-2022 11:45 AM
Hi All,   I'm trying to use Power BI to connect with SAS data sets with SAS Providers to OLEDB. The main issue is that when we connect we see all the libraries and tables from the SAS Workspace Server. Anybody knows if it's possible to specify a single library in the connection string?   We are using this string:   provider=sas.IOMProvider.9.46;data source=SASApp;mode=Read;sas cell cache size=10000;sas machine dns name= hostname;sas port=8591;sas protocol=2;sas server type=1   Thanks!   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-16-2023 12:02 PM
Group Hubs for davidmitrovic
View All
Quick links