Power Query SPO Doc library: turning off versioning breaks data load of CSV into PBI?

[OneWithQuestion]

We have a CSV file in an SPO doc library, and we found that if we turn off document versioning the PBI report can no longer refresh off the CSV saved to the SPO doc library.

When we open the power query editor we see that it still shows the file in the SPO list, and clicking on BINARY goes to the "next step" to open the file.

However, when it goes to open the file it no longer opens it as a CSV but as what is apparently a raw binary file and it errors out.

It loads it as a single column with the file contents listed out instead of treatng it like a CSV.

It is very odd.

Has anyone else encountered this?

It is interesting that the query shows it as

= Table.FromColumns({Lines.FromBinary(#"Sample_report2 csv_https://MYSPOSITENAMEsharepoint com/sites/test/PBIreadtest/",null,null,1252)})

specifically the null values at the end.

Is the file deleted from SPO and PBI is still trying to access it but not referencing it by name or something?

The behavior is just unexpected

[Anonymous]

@OneWithQuestion 

Is is possible the newest version of the CSV file does not supports loading into Power BI, because versioning feature in SharePoint Online creates a copy of items when someone changes a document, so that we can track every change to the document and revert to old version if needed.

Regards
Paul

[OneWithQuestion]

Yeah, I don't know how to address it.

It is very odd, and I don't understand the behavior.