Automatically export table from visual with Selenium

[anap1br]

Hello! I'm trying to use Selenium in python to access a report in app.powerbi.com and export data from a table visual automatically.

The problem is I can't select anything in the report. The script manages to find the elements but doesn't interact with them. I've also tried to see if there's a different frame I need to switch to, but I couldn't find any.

When I'm doing it manually I click in '...' More Options and Export Data.

Has anyone managed to do this? I'm open to new solutions that don't include Selenium

[simontaylor]

I will try to use Python with Selenium to achive this goal. Let's see.

[lbendlin]

Are you on shared capacity or on Premium?

Power BI performance analyzer allows you to "borrow" the DAX query for each visual, and you can then run that query in your XMLA endpoint of choice (DAX studio, SSMS, etc)

Opening this in DAX Studio gives:

// DAX Query
DEFINE
  VAR __DS0Core = 
    SUMMARIZECOLUMNS(
      ROLLUPADDISSUBTOTAL(
        ROLLUPGROUP(
          'Vulnerabilities'[Plugin ID],
          'Vulnerabilities'[Open Date],
          'Vulnerabilities'[Host],
          'Vulnerabilities'[Repeated],
          'Vulnerabilities'[Status]
        ), "IsGrandTotalRowTotal"
      ),
      "SumCount", CALCULATE(SUM('Vulnerabilities'[Count]))
    )

  VAR __DS0PrimaryWindowed = 
    TOPN(
      502,
      __DS0Core,
      [IsGrandTotalRowTotal],
      0,
      'Vulnerabilities'[Open Date],
      1,
      'Vulnerabilities'[Plugin ID],
      1,
      'Vulnerabilities'[Host],
      1,
      'Vulnerabilities'[Repeated],
      1,
      'Vulnerabilities'[Status],
      1
    )

EVALUATE
  __DS0PrimaryWindowed

ORDER BY
  [IsGrandTotalRowTotal] DESC,
  'Vulnerabilities'[Open Date],
  'Vulnerabilities'[Plugin ID],
  'Vulnerabilities'[Host],
  'Vulnerabilities'[Repeated],
  'Vulnerabilities'[Status]

and executing it gives: