Reading a spde file into power BI

[LinusH]

https://documentation.sas.com/doc/en/oledbpr/9.4/n0heigqkqll8u9n1d9beeqkh0n2f.htm

[AlanC]

I stand corrected. My examples are using OleDb. 

[AlanC]

I just did a quick test and connected to PowerBI: Instructions:

Go here: https://support.sas.com/downloads/package.htm?pid=2472#
Download the 1st driver (64 bit) and install it
Open PowerBI
Add OleDB datasource. Connection string: Provider=SAS.LocalProvider.1; Data Source=c:\temp\MySasData
See sample in attached picture

[alepage]

Hello,

When I click on build, I see a selection of OLE DB connector.

Which one did you use?

How do you pass the server name in the username?  host@username, 10.111.44.111@username ?

Does you file is hosted on a unix server ?

Up to now, all my connection tests failed

[AlanC]

Use this technique for testing: http://www.polyweb.com/blog/index.php/archives/17

Go to connectionstrings.com for info on the parts of the connection string. SAS will also have documentation on their allowed parameters.

No, I didnt test with Unix. It shouldnt matter: you are just reading a file.

[alepage]

I will try the proposed test.

What's about the SAS connector.  Which one will be more appropriate ?

[AlanC]

Use the local provider, 64 bit.

BTW, when I am at a client site and have to figure any DB connection string, I always use the UDL trick.