cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sahildoshi
Frequent Visitor

Power BI Desktop : CSV Web File Parsing Issue

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. 

CSV Parsing Issue.PNG

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 

1 ACCEPTED SOLUTION
sahildoshi
Frequent Visitor

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

View solution in original post

5 REPLIES 5
sahildoshi
Frequent Visitor

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

View solution in original post

V-lianl-msft
Community Support
Community Support

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
Super User I
Super User I

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@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.

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors