Refresh Excel file power pivot charts (ODBC connection)

Aspose.Cells Product Family
1

I have several Excel files that have Power Pivots and Power Queries using an ODBC connection to Oracle. I’ve tried to use RefreshPivotTables, RefreshData, CalculateData methods with no luck. I tried using datamashup but that still doesn’t refresh the queries or pivot tables.
Is there any way to update and refresh queries or pivot tables that are using ODBC and datamodel using only Aspose Cells?

2

@rickmeister

To keep progress on this scenario (“Refresh Excel file power pivot charts (ODBC connection) I have several Excel files that have Power Pivots and Power Queries using an ODBC connection to Oracle. I’ve tried to use RefreshPivotTables, RefreshData, CalculateData methods with no luck. I tried using datamashup but t…”), start by validating the hypothesis around InjuryDet2.docx: rmatMode.UseDestinationStyles); Section sectionToAdd1 = (Section)sectionToAdd.Sections.Last(); sectionToAdd1.PageSetup.SectionStart = SectionStart.Continuous; Paragraph lastPara = (Paragraph)sectionToAdd.LastSection.Body.Paragraphs.Last(… (source: docs.aspose.com).

This is a best-effort explanation based on partial or unverified information because No retriever returned supporting documents yet and Only low-trust or forum sources were retrieved; please validate it against official documentation once supporting evidence is available.

Checklist / next steps:

  • InjuryDet2.docx (docs.aspose.com): rmatMode.UseDestinationStyles); Section sectionToAdd1 = (Section)sectionToAdd.Sections.Last(); sectionToAdd1.PageSetup.SectionStart = SectionStart.Continuous; Paragraph lastPara = (Paragraph)sectionToAdd.LastSection.Body.Paragraphs.Last(…
  • CopiesTo.docx (docs.aspose.com): rmatMode.UseDestinationStyles); Section sectionToAdd1 = (Section)sectionToAdd.Sections.Last(); sectionToAdd1.PageSetup.SectionStart = SectionStart.Continuous; Paragraph lastPara = (Paragraph)sectionToAdd.LastSection.Body.Paragraphs.Last(…
  • Footer.docx (docs.aspose.com): rmatMode.UseDestinationStyles); Section sectionToAdd1 = (Section)sectionToAdd.Sections.Last(); sectionToAdd1.PageSetup.SectionStart = SectionStart.Continuous; Paragraph lastPara = (Paragraph)sectionToAdd.LastSection.Body.Paragraphs.Last(…
  • Share these hypotheses with support engineers alongside logs, code samples, and the exact SDK version so they can confirm the behaviour.
  • Question summary: Refresh Excel file power pivot charts (ODBC connection) I have several Excel files that have Power Pivots and Power Queries using an ODBC connection to Oracle. I’ve tried to use RefreshPivotTables, RefreshData, CalculateData methods with no luck. I tried using datamashup but t…
3

We are sorry but currently, Aspose.Cells does not support to refresh Power pivots or refresh query tables with data model or external database connection. A ticket was already logged with an id “CELLSNET-49449” for it.

Once we will have an update on it, we will let you know.