Linking Columns

[drrodion]

Hello Power BI Users,

I'm working with a large amount of data which is coming from a sas dataset. To import this data set into Power BI the R workaround was used which has been mentioned various other places online. Using this work around I found that my system crashed attempting to load the data set as one piece and had much more success splitting the data into multiple which contain various columns from the original. Leaving the identification number in each of these new smaller sets I was hoping to link them in Power BI. The problem I have encountered is that the identification code are repeated and thus any two data sets dont have unique values. In other words the data sets are in the same exact order as the original but with different columns but having the exact same identification code column. Any ideas on how to fix this issue would be appreciated otherwise I will attempt splitting the data by rows and then appending the queries.

Thank you,

[v-piga-msft]

Hi @drrodion，

Based your description, I understand that you want to get data from SSAS by R script. 

It seems that you only to remove the repeated identification code at the last step should fix the issue. You could have a try.

If you still have this issue, could you share some screenshots about your issue, so that we can help further investigate on it?

Best Regards,

Cherry

[drrodion]

Hello Power BI Users,

I'm working with a large amount of data which is coming from a sas dataset. To import this data set into Power BI the R workaround was used which has been mentioned various other places online. Using this work around I found that my system crashed attempting to load the data set as one piece and had much more success splitting the data into multiple which contain various columns from the original. Leaving the identification number in each of these new smaller sets I was hoping to link them in Power BI. The problem I have encountered is that the identification code are repeated and thus any two data sets dont have unique values. In other words the data sets are in the same exact order as the original but with different columns but having the exact same identification code column. Any ideas on how to fix this issue would be appreciated otherwise I will attempt splitting the data by rows and then appending the queries.

Thank you,