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 
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]

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 .