Spending 12 hour create a PBI file now Getting error

[admin11]

Hi All

I have spend last 12 hour create 1 file . after getting all the result i want , Now when i try to refresh , i get error .

When i go to data transformation , i see a lot of the error , like below , after clear below error , new error pop up. 

My PBI file :-

https://www.dropbox.com/s/27r10hc73bijui7/PBTI_V050.pbix?dl=0

Can some one advise me where i go wrong ?

Paul Yeo

[bcdobbs · Accepted solution]

Hi Paul,

It looks like you're combining files from a folder. Most likely your files have some variation in column names.

In your power query steps you need to try and remove steps that reference columns directly by name. Particularly change types, remove columns and renames.

Instead get the files in, use "Remove other columns" so you're naming the consistent columns you want to keep and then do change type and renames after that.

[admin11]

@bcdobbs 

I load from folder , actually what i need is load from sharepoint folder , now i try to refrest every 1 hour.