Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.