Export single column to separate sheets in Excel from Power BI

[Erin_]

I am trying to export an Excel spreadsheet from a Power BI table visual. Table includes things like truck number, delivery items, etc. I need this spreadsheet to be formatted with different truck numbers as different sheets and each sheet including all information about that truck. Is it possible to set 1 column to be split by sheet in the spreadsheet? I know this can be done in SSRS but this data is being exported by users from Power BI in a browser. How do I accomplish this?

[v-yiruan-msft · Accepted solution]

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