How can we open .sas7bdat files using Power BI? The solution I know is to convert to .csv files. What are the other ways? Does .xptfile work during import?
Thanks,
Rajesh.
I would recommend using Python in Power BI with the Pandas library to load a SAS dataset. I have minimal experience with Pandas and SAS, but I dont recall it being too terribly complex.
In my experience you are better off uploading your SAS data into SQL Server which Power BI works well with.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.