topic Re: Power BI and SAS datasets in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/Power-BI-and-SAS-datasets/m-p/679311#M14139 <P>In my experience you are better off uploading your SAS data into SQL Server which Power BI works well with.</P> Wed, 26 Aug 2020 00:19:31 GMT SASKiwi 2020-08-26T00:19:31Z Power BI and SAS datasets https://communities.sas.com/t5/SAS-Visual-Analytics/Power-BI-and-SAS-datasets/m-p/679230#M14137 <P>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?</P><P>&nbsp;</P><P>Thanks,</P><P>Rajesh.</P> Tue, 25 Aug 2020 17:53:46 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Power-BI-and-SAS-datasets/m-p/679230#M14137 rajredy7172012 2020-08-25T17:53:46Z Re: Power BI and SAS datasets https://communities.sas.com/t5/SAS-Visual-Analytics/Power-BI-and-SAS-datasets/m-p/679299#M14138 <P>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.</P> Tue, 25 Aug 2020 22:04:07 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Power-BI-and-SAS-datasets/m-p/679299#M14138 New2SASProgram 2020-08-25T22:04:07Z Re: Power BI and SAS datasets https://communities.sas.com/t5/SAS-Visual-Analytics/Power-BI-and-SAS-datasets/m-p/679311#M14139 <P>In my experience you are better off uploading your SAS data into SQL Server which Power BI works well with.</P> Wed, 26 Aug 2020 00:19:31 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Power-BI-and-SAS-datasets/m-p/679311#M14139 SASKiwi 2020-08-26T00:19:31Z