Forum Discussion
Export single column to separate sheets in Excel from Power BI
Hi Erin_ ,
If I understand you correctly, you want to talk about exporting the data of each truck on visual to each sheet. i.e. each truck's data corresponds to a sheet, right? If yes, I'm afraid that there is no direct method to achieve it in Power BI. You can export the data from a Power BI visual to a .csv file and then use a macro or a VBA script in Excel to split the data into separate sheets based on the values in a specific column. You can find more information on how to export data from a Power BI visual to a .csv file in the following link.
Export data from a Power BI visualization - Power BI | Microsoft Learn
Once you have the data in Excel, you can use a macro or VBA script to split the data into separate sheets.
How to Split Excel Sheet into Multiple Workbooks Using VBA (With Example) (yodalearning.com)
excel - Split Data into Multiple Sheets with VBA - Stack Overflow
Best Regards
Hi Erin_ ,
If I understand you correctly, you want to talk about exporting the data of each truck on visual to each sheet. i.e. each truck's data corresponds to a sheet, right? If yes, I'm afraid that there is no direct method to achieve it in Power BI. You can export the data from a Power BI visual to a .csv file and then use a macro or a VBA script in Excel to split the data into separate sheets based on the values in a specific column. You can find more information on how to export data from a Power BI visual to a .csv file in the following link.
Export data from a Power BI visualization - Power BI | Microsoft Learn
Once you have the data in Excel, you can use a macro or VBA script to split the data into separate sheets.
How to Split Excel Sheet into Multiple Workbooks Using VBA (With Example) (yodalearning.com)
excel - Split Data into Multiple Sheets with VBA - Stack Overflow
Best Regards