Forum Discussion
Issue loading SharePoint List in DataMart - Power Query fine, ETL load not
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?
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 .
4 Replies
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 .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.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.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!
