Forum Discussion
Trouble connecting to data source (Excel file, not in table format)
Community ChampionHi MillyF ,
one general limitation is that you cannot connect to xls files from Power BI, just xlsx.
Apart from that, I'm not sure that you're doing your transformations at the right place: You're showing a picture from when the data is loaded into the data model already.
But to reduce the columns imported, you need to do that in the query editor (Transform data) instead.
Thank you, this has been helpful to remove the columns I do not want to load. I am still facing an issue, though, as noted in my comment above.
- Nathaniel_C
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
