Export data from Power BI to excel

Like (1) Share

Report

Posted on 14 Jul 2024 11:42:22 by dims12

105

Hi All,

I have a data like this in power bi .

I want to generate file on the basis of ru.
In my data above 3 files should be generated with data corresponding to each ru A01,A02,A03.
How I can do this through power automate?

All responses (6)

Answers (0)

dims12 105 on 16 Jul 2024 at 11:56:55

Like (1)

Report

Re: Export data from Power BI to excel

I had been trying to use this, I have question related to get table and and add a row into a table. Have you passed dynamic values in this, not sure what to pass in this?
dims12 105 on 16 Jul 2024 at 10:52:14

Like (1)

Report

Re: Export data from Power BI to excel

Thank you so much. I will try this and let you know,
SudeepGhatakNZ 14,318 Most Valuable Professional on 16 Jul 2024 at 05:11:10

Like (2)

Report

Re: Export data from Power BI to excel

Use this excel template and the attached flow,

I have hardcoded the data in Compose 2 action. Replace it with the following action

Template.xlsx

PowerBItoexcel_20...
dims12 105 on 15 Jul 2024 at 23:23:04

Like (1)

Report

Re: Export data from Power BI to excel

could you please help me with this?
dims12 105 on 15 Jul 2024 at 09:29:19

Like (1)

Report

Re: Export data from Power BI to excel

I want this in excel format in SharePoint document library. The excel file name should have the RU name appended with it.
SudeepGhatakNZ 14,318 Most Valuable Professional on 15 Jul 2024 at 00:57:55

Like (1)

Report

Re: Export data from Power BI to excel

@dims12

What format do you want to generate the files in? Excel? CSV? Email?