Hello!
In the organization where I work, several PBI pages have been created, accessible through URLs of the form:
https://app.powerbi.com/groups/me/apps/112823...........8/ReportSection?experience=power-bi
For my purpose, I export to excel, the data with "current aspect" (I don't have rights for "underlying data", but it's enough) and I go about my job with them. The problem is that, if I want an updated data set, I have to do a new export.
The question is whether this process can be automated, whether a query can be created, so that with a refresh I have the updated data.
When I tried to make such a query, it led me to a pivot table with some fields from which I did not understand anything...
Thanks,
GI
Salut Gigi,
If you don't have access to source data, all you can do is export data, there is no connector to PBI online in power query.
OK, Catalin, it took me a week to recover from my shock 
...
Now...I don't know where to ask...is there a method in the Windows environment to automate a series of actions? Something similar to macro commands, in Excel...
You Can try VBScript, or:
Or:
https://www.autoitscript.com/site/autoit/
Or, write batch scripts:
https://www.howtogeek.com/263177/how-to-write-a-batch-script-on-windows/
Very interesting suggestions, Catalin; I read about them but, unfortunately, I cannot install either MKC or AutoIt on the my company computer. It remains to be seen if I will manage to make a ".bat"...
Thanks!
