Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

SSAS Import Removing Duplicates

Hello everyone,   I am currently importing our SSAS Model to Power BI as we need to do some development that is outside the scope of live connection. Each table has been importand individually and ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hey v-kkf-msft,

     

    Thanks for the response. I tried this but it also did not work.

     

    I ended up bringing in the data using SQL that brought in all the data with duplicates. It also loaded significantly faster so I'll stick with that approach.

     

    Thanks!

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi Anonymous ,

 

Have you tried importing the pk column into power bi at the same time, and then deleting that PK column?

 

    

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hey v-kkf-msft,

     

    Thanks for the response. I tried this but it also did not work.

     

    I ended up bringing in the data using SQL that brought in all the data with duplicates. It also loaded significantly faster so I'll stick with that approach.

     

    Thanks!