Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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. 

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    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

5 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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. 
      • v-lili6-msft's avatar
        v-lili6-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        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

  • prathyoo's avatar
    prathyoo
    Icon for Advocate II rankAdvocate II
    5 years ago

    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.