Forum Discussion
Querys in Power BI
- We need to create 2 sheets in YTD paid report a. Summary sheetb. Data sheet
- We have multiple calculations in Summary sheet Please find the below screenshots for your reference.
- By default, when user export the YTD report in excel it should download both summary and data tabs at a time. Please confirm is it doable in Power BI?
Thank you!
3 Replies
@Sahir_Maharaj , @bwarner87 , @CHaines - Can you please replay, if you know the solution for above quetion.
Thank you!
- CHaines
Advocate I
It looks like Power BI's native export goes to .csv files, which don't support tabbed data. Power BI supports R and Python coding, so you can definitely do something there. a quick google search gave this Power BI example using R code - https://youtu.be/2V9cLPXPemg
Here's a how to on the R code iteself R: How to Export Data Frames to Multiple Excel Sheets - Statology and the R package guide openxlsx package - RDocumentation
Here's and equivalent Python guide How to Write Pandas DataFrames to Multiple Excel Sheets? - GeeksforGeeks - CHaines
Here is a discussion from within this community involving people who clearly know more than me Export data from Power BI desktop into multiple ta... - Microsoft Power BI Community
