POWER BI is duplicating rows after loading in POWER QUERY

[massotebernoull]

Hello!

In Power Query I have 45 rows, but when I load in Power BI it duplicates. What should I do?

 (power query)

 (power bi)

My table is bigger than 45, but I filtred this just to show what is happening. I tried to import the table again, but it didn't work.

And there is no relation with any other table.

I need some help, please!

[massotebernoull]

I just found the error. It was some bug in the CRM that I uploaded. I fixed removing the duplicated lines.

[HotChilli · Accepted solution]

2 possibilities:

1. There's a crazy bug that exponentially increases the rows of any data loaded into powerbi.

2. There's a normal powerbi process that needs investigating to see what's going on.

-----

Let's go with theory#2 just now.  What's the data source?  Is there any filtering or complex transforms taking place.

Have you tested with a simple table using 'Enter Data' to see if it loads into powerbi OK?