Forum Discussion

WaldemarWiec's avatar
WaldemarWiec
New Member
4 years ago

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) l...
Need Help
v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

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.