Solved: Re: Datamart load Error

Sim_9 · ‎07-20-2023

I'm new to datamarts, i've tried connecting to a dataflow and it all went well.
Now i'm triying to get data from a sherepoint folder but after transforming data and all...., i get an error when trying to load the data.

i don't konw why i get a message saying totry and set load enabeled as false, but i've tried and it doesn't seem to work cause i start getting errors on the Transform file wich i find normal.
what to do , any ideas ...?

otravers · ‎07-20-2023

Try doing all your transformations in external dataflows, not in the datamart's dataflow.

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

View solution in original post

otravers · ‎07-20-2023

Try doing all your transformations in external dataflows, not in the datamart's dataflow.

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

Datamart load Error

Helpful resources

Power BI DataViz World Championships - June 2026

Join our Fabric User Panel

Power BI Community Update - March 2026