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?
@BILingualAnalytics
Ай бұрын
It's literally "FileLocation" we are just cleaning up the M code :)
@MrMeeseeksPiano
Ай бұрын
@@BILingualAnalytics hmmmm, I wonder if it's still the same if my power bi isnt in english. Also, what is M code?
@BILingualAnalytics
Ай бұрын
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.
@MrMeeseeksPiano
28 күн бұрын
@@BILingualAnalytics oooh, ok, got it. Thanks so much!
@GeronimoDiaz-y4y
10 ай бұрын
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!
@BILingualAnalytics
10 ай бұрын
Hey, yes absolutely possible! Try to look at “incremental refresh”. It should solve your problem :) let me know how it goes
@osPA78
Жыл бұрын
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!
@BILingualAnalytics
Жыл бұрын
It is a nasty little thing, right? But it's great that you could solve it!
@relonicabaldiviano7163
10 ай бұрын
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.
@BILingualAnalytics
10 ай бұрын
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
@Alan-ps2ul
3 ай бұрын
Excellent tutorial which has solved the problem I had with multiple files all with same name but different date stamp. Thank you so much
@BILingualAnalytics
3 ай бұрын
Happy to hear that! :)
@jdsenuk
4 ай бұрын
Many thanks for showing the 2 methods, definitely solved my problem and I learnt something new.
@BILingualAnalytics
4 ай бұрын
Good to hear the video was useful! :)
@zoltantoth2267
Жыл бұрын
Thank you, very interesting! Greetings from Hungary!
Пікірлер: 23