Automatically export the report in excel format to One-Drive

[goyalsa]

Hi BI Community,

I have made a report in Power BI and upload it to the BI online service. But now, I have to export the report manually and dump it into the one-drive so others can use it. 

I want to make it automatic to get rid of the manual work on a daily basis. I went through the post but could not find the correct way to do it.

Many thanks in advance!!

Kind regards,

Sahil Goyal

[goyalsa]

Hi @selimovd 

Apologies to reply late. I will work on it this week and let you know if it works 🙂

Thanks for your support.

Kind regards,

Sahil Goyal

[selimovd]

Hey @goyalsa ,

why don't you just grant access to the users on the specific report in Power BI Service? I think that's a lot easier.

If you really want to export it you can use the API to do that:

Reports - Export Report - REST API (Power BI Power BI REST APIs) | Microsoft Docs

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[selimovd]

Hey @goyalsa ,

did it work with the access to Power BI or the export with the API.

I'm curious if you could solve this issue 🙂

If my approach helped to make it work, I would be happy if you could mark it as solution ✔️. Like this, the next person who is stumbling across this post can see immediately what worked, without trying all the approaches for themselves.

If you need any help please let me know.

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic