Are PPT exports and Domo plugin visuals static?

froghunter
froghunter Member
edited July 3 in Charting

I've been working with PPT exports of charts as well as the Domo plugin for PowerPoint. I got the idea that these are dynamic— they update when something in Domo updates— but my experimentation does not confirm this. So, is there a reasonable way to do that? The exports and the Domo plugin methods do not work. I'm looking into embedding with Domo Everywhere links, but have so far had no success. Am I correct about these being static, and is there a way to do this dynamically? Thank you.

Tagged:

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓

    You’re correct that standard PPT exports and the Domo plugin for PowerPoint are generally static. The Domo PowerPoint plugin itself does not support real-time updates. Once you insert a chart or a report into PowerPoint using the plugin, it does not automatically refresh the data. You would need to manually update the data by re-inserting the content from Domo.

    You might consider Power BI integration or Domo API integration? Such as using Domo's REST API to fetch data from Domo and up date PowerPoint files programmatically.

    Fetch from domo….

    fetch('https://api.domo.com/v1/datasets/{dataset_id}/data', {
    method: 'GET',
    headers: {
    'Authorization': 'Bearer YOUR_ACCESS_TOKEN',
    'Content-Type': 'application/json'
    }
    })
    .then(response => response.json())
    .then(data => {
    // Process the data
    });

    Update PowerPoint…

    let pptx = new PptxGenJS();
    let slide = pptx.addSlide();
    slide.addText('Updated Chart Data', { x: 1, y: 1, fontSize: 18, color: '000000' });
    // Add your chart or table data
    pptx.writeFile('UpdatedChart.pptx');

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • ArborRose
    ArborRose Coach
    Answer ✓

    You’re correct that standard PPT exports and the Domo plugin for PowerPoint are generally static. The Domo PowerPoint plugin itself does not support real-time updates. Once you insert a chart or a report into PowerPoint using the plugin, it does not automatically refresh the data. You would need to manually update the data by re-inserting the content from Domo.

    You might consider Power BI integration or Domo API integration? Such as using Domo's REST API to fetch data from Domo and up date PowerPoint files programmatically.

    Fetch from domo….

    fetch('https://api.domo.com/v1/datasets/{dataset_id}/data', {
    method: 'GET',
    headers: {
    'Authorization': 'Bearer YOUR_ACCESS_TOKEN',
    'Content-Type': 'application/json'
    }
    })
    .then(response => response.json())
    .then(data => {
    // Process the data
    });

    Update PowerPoint…

    let pptx = new PptxGenJS();
    let slide = pptx.addSlide();
    slide.addText('Updated Chart Data', { x: 1, y: 1, fontSize: 18, color: '000000' });
    // Add your chart or table data
    pptx.writeFile('UpdatedChart.pptx');

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • Thank you. That's a clear answer.

  • EricVanDerEems
    EricVanDerEems Domo Employee

    The power point add-in is a little easier to do this in, you can just click "refresh all" and every card you've inserted into the power point will update with the latest data, but the only way to get the most up to date data in Domo is to view the dashboard in the browser.

    Have you tried App Studio at all? That might be the level of customization you need to be able to create exactly what you're looking to display right in Domo so you don't need to take it into power point.