cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver III
Resolver III

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

Accepted Solutions
Highlighted

hi, @nvpraveenyakkal 

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

4 REPLIES 4
Highlighted
Community Support
Community Support

hi, @nvpraveenyakkal 

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.
Highlighted

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. 
Highlighted

hi, @nvpraveenyakkal 

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

Highlighted

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors