How to solve PBI unable to load CSV file ?

[Anonymous]

Hi All

After i try to load from sharepoint , suddenly i notice that now my PBI unable to open CSV file from my note book. 

I have try to un-install and install the PBI desktop software , it still the same unable load CSV file.

I have try to load from sharepoint folder , it work fine. 

I have try to open the existing PBI file , it work fine  , but cannot refresh , i will get error.

Hope some one can advise me where go wrong ?

[Anonymous]

@Anonymous For rerfresh errors, please compare with data set if any column name has changed or deleted.

[Anonymous]

Hi Nikhi

The data set all still the same. Now when i open a new PBI file and i try to import CSV data to PBI , also get error. except i can import CSV from sharepoint.

Paul

[Anonymous · Accepted solution]

@Anonymous Can you share me the steps, how you are loading the CSV?

Are you doing as below- 

[Anonymous]

Hi Sir

Yes correct , i load by what you said , and now i try again.

now it appear new screen :-

and i am able to load the data :-

So i think i have found the issue , it is due to above setting i have change. as in the past i never enter ID and PW , after i enter ID and PW , all my old PBI file unable to open.

Now when i open my old PBI file :-

I stuck here. 

Edit , after enter the ID and PW , i select correct directory , it work fine now :-

Paul Yeo