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: 
BookmarkSubscribeRSS Feed
rajredy7172012
Calcite | Level 5 rajredy7172012
Calcite | Level 5

Power BI and SAS datasets

Posted 08-25-2020 01:53 PM (1657 views)

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.

0 Likes
Reply
2 REPLIES 2
New2SASProgram
Calcite | Level 5 New2SASProgram
Calcite | Level 5

Re: Power BI and SAS datasets

Posted 08-25-2020 06:04 PM (1621 views)  |   In reply to rajredy7172012

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.

0 Likes
Reply
SASKiwi
PROC Star SASKiwi
PROC Star

Re: Power BI and SAS datasets

Posted 08-25-2020 08:19 PM (1604 views)  |   In reply to rajredy7172012

In my experience you are better off uploading your SAS data into SQL Server which Power BI works well with.

0 Likes
Reply

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Watch Tips for filtering data sources in SAS Visual Analytics on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • ‎08-25-2020 01:53 PM
  • 1658 views
  • 0 likes
  • 3 in conversation