Forum Discussion
Responsive ResidentChange excel to csv during data transformation
Hi ALl,
I am getting data from the sharepoint. Files are in an excel format. I need to change excel to csv format during data transformation. I never done. Please advise. I will appreciate it. Thanks
Hi sdhn
Data transformation cannot convert excel to csv,but you can do it in Desktop view .
You can load the data from excel file , then add a table visual to display the data ,then export data as .csv format .
More info about Export data can refer to the link below .
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data
Best Regard
Community Support Team _ Ailsa Tao
7 Replies
- AlexisOlson
Super User
What do you intend to do with it once you have it in CSV format?
sdhnI have multiple excel files resides on Sharepoint.
I connecte dto sharepoint but not getting all loads on based of my some calculated column condition. When I saved file in CSV format at my PC. I got everything fine.
- AlexisOlson
OK. That's doesn't really answer my question though.
Your ultimate goal is for these Excel files is to load them from SharePoint and save them on your local PC in CSV format?
Hi sdhn
Data transformation cannot convert excel to csv,but you can do it in Desktop view .
You can load the data from excel file , then add a table visual to display the data ,then export data as .csv format .
More info about Export data can refer to the link below .
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data
Best Regard
Community Support Team _ Ailsa Tao
