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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Helper I
Helper 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
Helper I
Helper 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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.