Forum Discussion
Help with linking to Sharepoint folder
Hi I have a model linked to a Sharepoint folder with multiple Excel files in the same format - essentially financial data extracted on a monthly basis is added to a folder by another department (...
Hi knagarlmet ,
When you refer that the PBI reads some files from A2 and other from B2 does that mean that on some files the information starts on A2 and on other on B2 or is PBI skipping some data on files that have data on A2?
For making this type of automated transformation based on Folders (sharepoint or others) you need to be sure that the files are all formated the same way meaning that they all have the same number of columns, they all start at the same column, etc. If this does not happen you need to add transformation steps that will allow to overcome those differences between the files.