How to export PBI data into Excel automatically on daily basis

[Uzi2019]

Hi Experts,

I have a some urgent requirement to export the PBI data into Excel on daily basis. That Excel should be accessible to the end users.

Can anyone please guide me towards a right direction ?

Many Thanks in advance!

[Syndicate_Admin]

! Hello!

Did you manage to find a solution? I'm going through the same problem,

Best regards

[v-eqin-msft]

Hi @Uzi2019 ,

Could you tell me if my post helps you a little? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Hope to hear from you‌‌

Best Regards,
Eyelyn Qin

[Uzi2019]

Hi @v-eqin-msft ,
Thank you for your reply, But your solution didn't work out for me. I am getting an error while creating flow. I am still trying to figure out the solution.

[v-eqin-msft]

Hi @Uzi2019 ,

According to this thread:

An idea similar with automatically export data automatically on daily basis has been submitted in the following link, please vote it up and you can add comments in this idea:

Automatic data snapshots/export data

Please refer to the tutorials to see if it could help you a little:

How to Auto-Schedule Data Export From Power BI

Tutorial: Export Power BI Reports to CSV Automatically

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Uzi2019 , You can check for power automate

https://www.youtube.com/watch?v=BnTipbooeP0

rest API - https://docs.microsoft.com/en-us/rest/api/power-bi/reports/exporttofile

[Uzi2019]

Hi @amitchandak ,
I have already tried that method  but I got stuck at (create csv table)step. After running a flow, showing error  input to this flow is null, even I did the same as per the video. but every time showing the same error. can you please create a same flow n let me know whether are you able to run a flow successfully or not.

Thanks in Advance