Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

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

vanessafvg's avatar
vanessafvg
Community Champion
5 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      vanessafvg
      Community Champion
      5 years ago

      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?