Forum Discussion
Trouble connecting to data source (Excel file, not in table format)
I manage an Excel file that contains 222 columns and it currently has around 2000 rows. The file size is around 3.39MB. It is not in Table format and it has many custom formulas. Power BI cannot conn...
Nathaniel_C
Community Champion
Community Champion
Is that portion of the bar being red an indication that data needs to be cleaned up?
- Nathaniel_C
Try going to view and checking the boxes in the picture to get additional information regarding your columns
https://docs.microsoft.com/en-us/power-query/data-profiling-tools
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel