Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Ramanjaneya
Regular Visitor

Querys in Power BI

Hello Team,
 
We have requirement in Power BI, I have reviewed and suggested few things to business which are not doable in Power BI. Please suggest/add your comments if it is possible in Power BI.
 
Requirement:
  1. We need to create 2 sheets in YTD paid report 
          a. Summary sheet
          b. Data sheet
  2. We have multiple calculations in Summary sheet Please find the below screenshots for your reference.
  3. 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?
Ramanjaneya_4-1677081371929.png

 

Ramanjaneya_5-1677081371931.png

 

Ramanjaneya_6-1677081371933.png

 

Ramanjaneya_7-1677081371934.png

Thank you!

 
3 REPLIES 3
CHaines
Advocate I
Advocate I

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

CHaines
Advocate I
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

Ramanjaneya
Regular Visitor

@Sahir_Maharaj , @bwarner87 , @CHaines - Can you please replay, if you know the solution for above quetion.

 

Thank you!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.