Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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 I've connected the data model.

 

We are only using a couple of columns from the fact table as it is huge. The problem is that many of the rows are the now the same and PowerQuery is automatically removing duplicates. I can prove this because when I import the PK, the SUM of the rows increase to the correct number. Unfortuntely, as expected, importing the PK increases the file size by 10x. 

 

Has anyone experienced this before? Is there any workaround? I do not believe PowerQuery is designed to automatically remove duplicates so I'm a bit stuck.

 

Cheers!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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!

View solution in original post

2 REPLIES 2
v-kkf-msft
Community Support
Community Support

Hi @Anonymous ,

 

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

 

vkkfmsft_0-1638761307556.png    vkkfmsft_1-1638761353418.png

 

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
Not applicable

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!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.