Issue loading SharePoint List in DataMart - Power Query fine, ETL load not

[TERRY_HUGHES]

Creating a simple datamart that contains a SharePoint List. The list is around 10k rows.

In Power Query I get the data and PQ does it's standard transforms, and the data is correct.

ID	SKU	ACTION	NOTES
1	Sku1	AAAA	A note here
2	Sku2	BBBB	Different Note Here
3	Sku3	CCCC	Yet something else here
4	Sku4	DDDD	And now for something completly different
5	Sku5	EEEE	Its

I then save the Query and something strage is happening during the ETL. The final table has 2 columns where the data is correct, ID and my key column, all the other columns it is duplicating one row. 

ID	SKU	ACTION	NOTES
1	Sku1	AAAA	A note here
2	Sku2	AAAA	A note here
3	Sku3	AAAA	A note here
4	Sku4	AAAA	A note here
5	Sku5	AAAA	A note here

I can load the same sharepoint list into PBI desktop via Power Query and it imports correctly, its only happening in the PBI Datamart service.

Why?

[v-csrikanth]

HI @TERRY_HUGHES 
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

[v-csrikanth]

Hi @TERRY_HUGHES 

We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @TERRY_HUGHES 
As highlighted by @lbendlin , the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resolve
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[lbendlin · Accepted solution]

Datamarts make no sense for single tables. You can cover that scenario with a dataflow.

Anyhow, If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .