Forum Discussion
power bi reference source renamed/chanced - error on syntax
HI cosminc,
Please share more detail information to description your operation more clearly, it is hard to troubleshooting your issue without any detail description.
Regards,
Xiaoxin Sheng
- cosminc7 years agoPost Partisan
Hi
let's say i have a new pbi; when i choose a folder source - combine&edit it appears up on the left side this
and it takes a reference source
the problem is later when this reference source is no more on that folder
pbi looks after its name and returns an error because it don't find it.
How can i make pbi to be versatile and not take in consideration a name source as reference which can be or not later; think on this situation: this year i use 3 excels sources named 2016, 2017 and 2018 and the reference is one of them let's say 2016; next year i will have other years data than this reference 2019,2020 and 2021. i don't want to give me an error when the refference dissapears, the structure of the data is the same on all excels.
thanks,
Cosmin
- Anonymous7 years agoNot applicable
Hi cosminc,
If this is a case, I'd like to suggest you only use folder connector to get file list without do any combine operations.
Then you can create a custom table with specific table structure which you wanted, then manually to merge operation through table functions with list of excel files reference from above steps.
Reference links:
Creating Tables In Power BI/Power Query M Code Using #table()
If you still confused on coding query formula, please share some sample excel files and expected result so that we can test to coding formula.
Regards,
Xiaoxin Sheng