CSVs on SharePoint Refresh failure and 0x80040E4E Error on Desktop App

[DataDove]

Hi everyone. This is my first post/question to the community 🙂

I am reporting on my company's antivirus software. I have a schedule set up that emails me 7 different csv's containing data from that day. I have a Flow set up that saves the files to SharePoint.

1. My source looks like this: SharePoint.Files("https://domain.sharepoint.com/sites/MYSHAREPOINTSITE", [ApiVersion = 15])
2. I don't have any joins, each table is a query on its own.
3. I don't have any funny relationships, everything is one-to-many (I have a calendar and a table with users that link to the rest)
4. I have checked all the dates in the csv's - nothing out of the ordinary.

When I refresh/apply changes on my .pbix file I get this error (the table in which the error was found, changes every time):

When I refresh my report on the service, I get this error (the table in which the error was found, changes every time): 

However, even though I get a refresh failure, the data on the report is up to date.

This report used to work perfectly fine, I haven't changed anything. The failures started about a month ago and never stopped.

I would really appreciate some help.

[Anonymous]

Hi ,

Mainly we have 2 reasons for this error.

1. In the source level Column data type changes , Column name changes, Case sensitive issues, Source path issues, etc..

2. In the Power bi desktop level, Version issues and in the advanced editor please check the column formatting or renaming etc..

So please check all the scenarios again.