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

[Anonymous]

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. 

[prathyoo]

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]

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

[Anonymous]

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. 

[VuongLM93]

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

[v-lili6-msft · 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