Forum Discussion
SharePoint Excel files import issue
Hi,
I am importing a set of Excel files from SherePoint site to Power BI app. It worked perfectly until last week. Then in Power Bi data source tables I discovered "doubled" files (Source.Name) like this:
FileName.xlsm
FileName_CD51E136-2F49-445F-9300-4435182131422021-12-02T03-21-10.xlsm
the second one looks like some old version of the first one. It is not seen in the SharePoint directory and I cannot track it in any way.
I found the walkthrough filtering this out manually, but this is not a perfect solution. Does enyone meet such an issue?
2 Replies
Hi WaldemarWiec ,
You can check in SharePoint to see if it is in the historical version of the file.
Just as a workaround, you could create a table [Name] containing the names of the excel files you want to import, like this.
Then add the following code in the advanced editor of the SharePoint data source to filter the excel files contained in table [Name].
#"Selected Rows" = Table.SelectRows(#"Filtered Rows", each List.Contains(Name[Table Name], [Name]) )If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi WaldemarWiec ,
Has your problem been solved? If it is solved, please mark a reply which is helpful to you.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
