Log In
Register
Home
February 10, 2020
Offline
Hello!
In the organization where I work, several PBI pages have been created, accessible through URLs of the form:
https://app.powerbi.com/groups.....pps/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
See Answer
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
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.
February 10, 2020
Offline
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...
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
You Can try VBScript, or:
https://support.microsoft.com/.....eeb04da2fb
Or:
https://www.autoitscript.com/s.....te/autoit/
Or, write batch scripts:
Answers Post
February 10, 2020
Offline
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!
1 Guest(s)
