Forum Discussion
Helper IILoad was cancelled by an error in loading a previous table
Issue resolved with no specific resolution.
I saved offending query M code, deleted query, recreated query using saved M code, and now it works.
I haven't see any info on how to read the Tracing logs. Can anyone say if these would hold relevant information to troubleshoot issues like these?
Sometimes the error messages in UI are not enough.
!Hi!
Same thing happened to me. I did the process from zero again, the only difference was that I used Direct Query instead of Import Query. I think that as Import Query copied a Database maybe when the relationships or transformations that you do could trunk something.
So, try with Direct Query instead of Import Query when you get the data.
It worked for me.
Hello, just curious as to how do I do a direct query instead of import query how to do that? Hope I'm understanding this correctly as I'm currently importing my data from excel files but recently gotten direct access to the database system, so would like to learn and better understand how to do this more efficiently so that my report automatically pulls the data directly from source itself when I do a refresh..