Forum Discussion

Mauro89's avatar
Mauro89
Icon for Super User rankSuper User
10 months ago
Solved

CSV to table not working from Lakehouse File section

Hi community,   I have a CSV file which I manually uploaded to a Lakehouse files section. Neither creating a delta table directly or accessing the file from a Dataflow Gen2 does not work as the se...
one lake
  • Mauro89's avatar
    Mauro89
    9 months ago

    The encoding is UTF-8, very standard. I guess there might me another issue which is just not known currently. For now as non of the mentioned options actually solved the issue I see the workaround using the inport directly in Power BI as only solution. 

    Thanks and best regards. 

Mauro89's avatar
Mauro89
Icon for Super User rankSuper User
9 months ago

Hi v-kpoloju-msft,

 

sadly the provided tips do not work. Still not able to load this specific CSV file from OneLake. 
How to proceed if no proper answer is given or solution exists?

 

Besr regards!

nielsvdc's avatar
nielsvdc
Icon for Super User rankSuper User
9 months ago

Please use a tool like vscode or Notepad++ to see what the encoding of the file is. This might give you a hint about how to solve your problem. If the encoding is not UTF-8 or the delimiters or not a commonly used delimiter, you probably need to configure the Power Query M code accordingly.

 

As we are not able to look with you at your specific situation, you unfortunately need to figure out the solution for your particular case.

  • Mauro89's avatar
    Mauro89
    Icon for Super User rankSuper User
    9 months ago

    The encoding is UTF-8, very standard. I guess there might me another issue which is just not known currently. For now as non of the mentioned options actually solved the issue I see the workaround using the inport directly in Power BI as only solution. 

    Thanks and best regards.