Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
I will try to use Python with Selenium to achive this goal. Let's see.
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: