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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Automated Data Export from Table visual in Power BI Service into SharePoint

I have power bi report built on top of ssas tabular model using live connection. I wanted to export data from table visual and upload it into sharepoint every day. Is there any way that i could acheive this ? like using R script or Microsoft Flow...?

 

Any Help would be greatlty appreciated. 

1 ACCEPTED SOLUTION

hi, @Anonymous 

According to my knowledge, Automated Data Export from Table visual is not available for now.

So for your requirement, I'm afraid it couldn't achieve in Power BI for now.

 

Best Regards,

lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
prathyoo
Advocate II
Advocate II

Will the Power Automate action for Power BI work? There seems to be an option to select a report and then further select a visual in the Export Power Report action. 

v-lili6-msft
Community Support
Community Support

hi, @Anonymous 

After my research, I'm afraid it couldn't achieve in Power BI for now.

For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner.

 

By the way, It is not possible to just automate export table from Power BI Service for now, there is an idea about this issue, you can vote it up.

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

I was able to export data from the visual using R Script and upload into one of our shared drives by using this 

write.csv(dataset, file = "//xxdrive/shareuse/new folder/dataset.csv")
But I couldn't figure out a way to autoamte this process when published to service and couldn't fugure out on uploading to sharepoint.
I have strong feeling that we might be able to do using R Scripting. Please have a look into this... Let me know your insights.
 
Thanks for your response. 

@Anonymous  I was also looking for the exact same thing, I want to export my sales data from a report online in PBI service

hi, @Anonymous 

According to my knowledge, Automated Data Export from Table visual is not available for now.

So for your requirement, I'm afraid it couldn't achieve in Power BI for now.

 

Best Regards,

lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 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.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors
Top Kudoed Authors