My PBI unable to load from CSV file from one drive folder

[Anonymous]

Hi All

Last 3 week i have create many version of PBI file. Now all the file when open no issue ,

But when i refresh , i will get error msg " 

Now when i try to create a new PBI file , and when i try to load a CSV file from my one drive folder , i also get error msg.  But when i load from sharepoint folder i dont have any issue. 

I have un-install the PBI desktop , still the same. 

Hope some one can share with me where i go wrong ?

PAul Yeo

[Anonymous · Accepted solution]

@Anonymous 

I had similar issue with the same error message.

Solved it by clearing all global permissions and clearing cache.

Clear Global Permissions:

File>Options and settings>datasource settings>Global permissions>Clear all permissions.

Clear Cache:

File>Options and settings>Options>Clear Cache

After these steps, I was able to connect to my datasource.

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍

[Anonymous]

@Anonymous Please check and compare the file which is loaded in power Bi has the same column names, in data source location.

Seems like some column name would have changed at origina,l data source which is causing a problem.