Forum Discussion

Scute's avatar
Scute
New Member
2 years ago

Export data from chart as a new data source

Hello,

 

I have been unable to find a good solution for this...

 

I want to export data from a couple of created charts as new data sources in the BI, to allow me to do some simple data manipulations and produce a combined chart of them together. It is not possible to do manipulations to produce the combined chart without this, currently I'm having to export the data out into csvs and load it back in which is not automated.

 

Is there a quick fix for this?

 

Thanks,

 

Scute

Need Help

3 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi Scute 

    Please do the manipulation in Power Query editor, so it will be automated. You can create combined tables for creating combined charts in Power Query.
    I am not sure the manipulation you are doing every time is the same.


    Let me know if that works for you


    If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

  • Scute's avatar
    Scute
    New Member
    2 years ago

    Thanks for the reply.

     

    Unfortunately, that would still require me to export the data in the charts as csvs so I can't automate that step. Is there a way I can get the information from a chart directly to power query?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Scute 

       

      Power BI does not natively support exporting data from visuals directly back into the model as a new data source.

       

      If you're looking for automation, consider using the Power BI API.You could automate the process of exporting data to CSV, transforming it externally (if necessary), and then importing it back into Power BI using a script (PowerShell, Python, etc.) that leverages the Power BI REST API to refresh the dataset in Power BI.

       

       

       

       

       

       

      Best Regards,

      Jayleny

       

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