I was having this exact same issue with one of my reports and as soon as I saw that you received the exact same error message I almost jumped out of my chair. Once I found the error of my ways and made the correction...my report was no longer giving me the error. Thank you so much for this video!
Thank you for sharing! This is awesome and somehow similar to what I am looking for. However, my folder path is coming from SharePoint. I applied the same process to option 1 but am having a hard time figuring out how to update the path so it won't cause an error when another file is uploaded in a separate week. Would you please help? Thank you.
Not sure how it works with Sharepoint, but you can also just load the whole SP folder and in PQ sort by creation date - and then use option 1. Let me know if that helps
At 3:25 when you edit the advanced code thing and enter "FileLocation" is that exactly what I'm supposed to enter? Or should I put the actual address from my file? What if it's a sharepoint folder?
You can use whatever name you want to use. It’s just a renaming step. So if someone else comes in and goes through your report they’ll know what its all about.
Roland, first of all, thanks for share these important information. Now, I have a question. I have a power bi file to analyze the revenue of each month of every year of an organization. Each .cvs file have 180mb and every time I want to add the new one, power bi load every file again. It takes a lot of time because I have 15 files now. So I need a way to add the latest without losing the information of the others and keep the way power bi identify each file with a "Source Name" column. Is that possible? Thanks!
I was having this exact same issue with one of my reports and as soon as I saw that you received the exact same error message I almost jumped out of my chair. Once I found the error of my ways and made the correction...my report was no longer giving me the error. Thank you so much for this video!
It is a nasty little thing, right? But it's great that you could solve it!
Excellent tutorial which has solved the problem I had with multiple files all with same name but different date stamp. Thank you so much
Happy to hear that! :)
Many thanks for showing the 2 methods, definitely solved my problem and I learnt something new.
Good to hear the video was useful! :)
Thank you, very interesting! Greetings from Hungary!
Orulok, hogy tetszett! :)
Thank you for sharing! This is awesome and somehow similar to what I am looking for. However, my folder path is coming from SharePoint. I applied the same process to option 1 but am having a hard time figuring out how to update the path so it won't cause an error when another file is uploaded in a separate week. Would you please help? Thank you.
Not sure how it works with Sharepoint, but you can also just load the whole SP folder and in PQ sort by creation date - and then use option 1. Let me know if that helps
You are awesome mate. This is a life saver.❤
I'm glad it helped you! :)
At 3:25 when you edit the advanced code thing and enter "FileLocation" is that exactly what I'm supposed to enter? Or should I put the actual address from my file? What if it's a sharepoint folder?
It's literally "FileLocation" we are just cleaning up the M code :)
@@BILingualAnalytics hmmmm, I wonder if it's still the same if my power bi isnt in english. Also, what is M code?
You can use whatever name you want to use. It’s just a renaming step. So if someone else comes in and goes through your report they’ll know what its all about.
@@BILingualAnalytics oooh, ok, got it. Thanks so much!
Thank you for this video
Glad you liked it!
thank you for sharing 👌
Glad you liked it!
Roland, first of all, thanks for share these important information. Now, I have a question. I have a power bi file to analyze the revenue of each month of every year of an organization. Each .cvs file have 180mb and every time I want to add the new one, power bi load every file again. It takes a lot of time because I have 15 files now. So I need a way to add the latest without losing the information of the others and keep the way power bi identify each file with a "Source Name" column. Is that possible? Thanks!
Hey, yes absolutely possible! Try to look at “incremental refresh”. It should solve your problem :) let me know how it goes