Forum Discussion
Connecting to SAS
Hi all,
I was wondering if anyone has had any luck connecting PBI to a SAS dataset? I've had a quick search and seen the mention of ODBC a lot, is this the most efficient method?
EDIT: I want to avoid exporting SAS files entirely!
Kind regards,
Jordan
3 Replies
- v-eachen-msft
Community Support
Hi Anonymous ,
From the official document, you could use OLE DB.
Here is the link for you reference.
Here is a topic from SAS community, you could also refer to it.
https://communities.sas.com/t5/SAS-Data-Management/SAS-Share-and-Power-BI/td-p/551745#
- amitchandak
Super User
Anonymous , refer if this can help
https://phejndorf.wordpress.com/2017/07/02/importing-sas-data-into-powerbi/
No luck with this unfortunately Amintchandak (even when editing file path to remove _). It seems this method suggests connecting to a SAS export anyway, which is what I'm looking to avoid. I'm looking to remove the need to constantly export files to our network. Thnk you for the suggestion though.
EDIT: realise that I didn't make it clear in my initial post, I want to avoid exports.
