Forum Discussion

cosminc's avatar
cosminc
Post Partisan
7 years ago

power bi reference source renamed/chanced - error on syntax

Hi, when i use a folder as source with multiple excels power bi takes on first steps a reference from these excels; when this reference is deleted/changed/renamed i have error when i reload. Any ti...
Need Help
cosminc's avatar
cosminc
Post Partisan
7 years ago

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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()

Table.Combine

 

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