Issue with reports connected to Sharepoint files

[laurenm]

We seem to be encountering multiple different issues that are related to sharepoint .xlsx files in the reports.

For some, the desktop file no longer recognizes the file types in the sharepoint location giving the error that FileLeafRef.Suffix cannot be found.

We have gotten around this by not referencing the column with the file type prior to expanding it but it's not really a fix.

Also, we have a file that has a SQL connection filtered by files in a sharepoint connection and then those files replace rows in the table. This works great in the desktop file but once it's pushed to the service PBI skips the filter step so our totals are essentially doubling. No amount of re-publishing, etc gets it to work properly.

[v-lili6-msft]

hi  @laurenm 

It is a known issue and should be fixed recently.

here is the post, please refer to:

https://community.powerbi.com/t5/Service/Expression-Error-The-field-FileLeafRef-Suffix-of-the-record...

and I have tested it on my side, it works well, you could also try it again and see if above post solution could help you.

Regards,

Lin

[laurenm]

Wonderful news, thank you!