Forum Discussion

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
6 years ago

Copying data from PowerBI to a PowePoint chart (with format)

Dear all, Is there a way to copy the date from a table created in Power BI, including format, directly to Excel or a chart in PowerPoint? Imagine we generate a very simple table like the following ...
Need Help
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
6 years ago

Hello AlB 

What if you hook to the model using Analyze in Excel and build the visual from there?  You would only have to build in once in excel then you can refresh it against the model.

 

Or, you could copy the page from the .pbix with the graph you are trying to export into a .pbix by itself then publish and from PowerBI.com export to PowerPoint.  

I only mention making a copy because it sounds like you don't want the entire report, just the one graph.

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    6 years ago

    jdbuchanan71  Thanks for your swift response.

    I didn't specify it in the question but I am mostly looking for a solution for Power BI Desktop. Two questions:

    1. Are both options you suggest only availbale in the Power BI service? I understand they are not available in Power BI Desktop?

    2. The Analyze in Excel option is not available in the free version of the service, is it?

     

    Many thanks    

    • jdbuchanan71's avatar
      jdbuchanan71
      Icon for Super User rankSuper User
      6 years ago

      1. I believe so.  I don't think you con do either if the report has not been published to the Power BI service.

      2. You can use analyze in excel with just a pro license.