Power BI Desktop : CSV Web File Parsing Issue

[sahildoshi]

Hello All, I am new to Power BI and facing some issues while loading a CSV file located on web. When I try to load it, instaed of getting structured CSV data, I am getting the corresponding HTML code inside one single column. Please refer below snapshot. Rest all of the columns are empty. 

I tried googling the issue but couldn't find any solution. 

Here is the code I have used while connecting to the csv file.

let Source = Csv.Document(Web.Contents("URL"), [Delimeter = "," Columns = 91, Encoding = 65001, QuoteStyle = QuoteStyle.None])

The weird part is, when one my colleague tries to load the same file with same code, she is getting proper structured CSV response as expected. I am using May 2020 version.

Also, I have also done -> Data Source Settings -> Change Source -> Open File As = CSV.

Please help me resolve this, I am stuck on it from past 2 days. @Greg_Deckler @amitchandak 

[sahildoshi · Accepted solution]

I was able to finally achieve it by passing the authentication header while connecting to the web csv.

[V-lianl-msft]

If you let your colleagues share pbix with you, will such issue arise? If you upgrade PBI Desktop, will the problem still exist?Please try to see the result.

[vanessafvg]

have you compared the code from her import on her machine to yours in the advanced editor code of power query in yours?

other things that might affect is i think could be regional settings although that is a wild guess.  I would start with comparing what she is doign vs what you are doing.  Also compare regional settings under advanced regarding delimiters etc.

[sahildoshi]

@vanessafvg thank you for your reply. I have copied my colleague's code only from advance editor. Recently, one of my other colleague was able to fetch data properly, but now she is also facing the same issue as me. The only change she did was upgraded to May 2020 version.

[vanessafvg]

May 2020 or 2021?  that seems  like quite an old version of Power BI.  Best to have the latest which is July 2021 if you are able to update it yourself?