Automating Export data workflow

[atr1]

Hi I am interested in automating my current workflow which looks like this:

1. I go to a power bi report at https://app.powerbi.com/
2. Hover over a visual that I am interested in and hit the elipses
3. Click export data as summarized data
4. Downloaded file is then fed to a PBI on my desktop 

I do not have access to the raw data that is uploaded to the publsihed report in step 1.

I feel like there should be a way to pull up this data directly on the PBI that I've got locally, will that be possible?

Or alternatively, is there a way to automate the process of downloading this data?

I am currently using RPA with computer vision to scrape the data but this hasn't worked well as of late.

Thanks

[TomMartens]

Hey @atr1 ,

you can use this API to request a result from a DAX query: https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries

Have you considered connecting to the dataset from your local pbix file directly, your requirements looks like it can be solved using the composite model feature: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models

Hopefully, this helps to tackle your challenge.

Regards,

Tom