Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
My raw data is CSV only one field :-
When i use PBI to import the above file , i keep getting this screen below and data not import in :-
Solved! Go to Solution.
Hi @Paulyeo11
Could you tell me if your problem has been solved? If it is, kindly Accept the helpful reply as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Rico Zhou
Hi @Paulyeo11
Could you tell me if your problem has been solved? If it is, kindly Accept the helpful reply as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Rico Zhou
Hi @Paulyeo11
In addition to NikhilKumar 's reply, you can import csv file from open as like NikhilKumar 's reply.
Or you can right click the Csv file in Power Query Editor and select Text as below.
If you open as Excel, it may show error and you need to edit settng to open file as Csv document.
Result:
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Paulyeo11
You can double click the file icon to extract the content.
How to did you connect the file, using Text/CSV or any other method?
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Paulyeo11 - In top left in Power Query, you could see an option "Open As" - Click over that and select Text file. That should work
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |