Forum Discussion

BAFreedom's avatar
BAFreedom
Icon for Helper I rankHelper I
4 years ago
Solved

How to import a "File" File Type Into Power BI

Hello,

 

 I received a list of files with data I'd like to clean. It is not under excel. Under file type, it says "File."

 

This is the first time I've seen it... I am not able to see the file contents, nor do I know what they are. I presume, they are reports.

How do I import it into Power BI, such that it is easily cleaned?

Need Help
  • Watsky's avatar
    Watsky
    4 years ago

    Hiya BAFreedom,

    It sounds like the files you were given had thier file extensions removed. You'll need to try to add a file extension to the end of the file and see what the file type actually is. I would start with  .txt or  .csv and see if you can open the file with either extension.

1 Reply

  • Watsky's avatar
    Watsky
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hiya BAFreedom,

    It sounds like the files you were given had thier file extensions removed. You'll need to try to add a file extension to the end of the file and see what the file type actually is. I would start with  .txt or  .csv and see if you can open the file with either extension.