Forum Discussion
Solved
import folder breaks when adding a new excel file
Hi I am trying to figure out how to troubleshoot some import errors. I have a folder with 2 excel files that I imported as my data source. I added a 3rd excel file that potentially has new or missin...
Hi sedric1 : the first thing to check is corresponding M Code generated by Power BI.
You can click on small gear icon on each step (Source/Filter File1/Function1 etc) and try to understand if they are not showing any error.
If any step is giving error, try removing that step and see if the problem solves. If yes, that means that was the problamatic step and you might have to rethink the logic for implementing that one again in a different way. Else if the problem still exists there must be another step further down which might be causing the conflict.
Let me know how you go, or if you can share sample PBIX file, i can try helping out.
Happy debugging 🙂
Thanks,
Namish