web

[power]

Hi POWER BI folks,

I have done simple WEB DATA pulls where the source is just hyperlinked ( e.g. getting CSV data from the link).

Now I am trying to get the data from my portal that requires password AND before downloading all data there are 2 functions:

1. that just does select all 

<a id="btnSelectAll" class="important" href="javascript&colon;__doPostBack('ctl00$cphMain$btnSelectAll','')">Select All</a>

and 

2. an export link that executes export of data  to excel ( now this link is more like simple web data pull) 

 

http://imgur.com/9hYhivM

<a id="btnExportAll" class="important" href="javascript&colon;__doPostBack('ctl00$cphMain$btnExportAll','')">Accounts &amp; People</a>

It looks like a 2 step process , ( manualy i log in , go to this page and click on the link selet all accounts, click on the export all accounts and excel is now on my computer-- then i just pick it up with POWER BI and i get a cool updated report in POWER BI) 

Now can we use POWER BI to kinda tell POWER bi TO CLICK CLICK CLICK and automate these 3 steps ? 

@vrossouw  @ImkeF,@MarcelBeug

[v-ljerr-msft]

Hi @power,

I am wondering if it is possible for you to use your api to call the functions needed with power query like what has done in this article in your scenario. 

Regards

[power]

Hi POWER BI folks,

I have done simple WEB DATA pulls where the source is just hyperlinked ( e.g. getting CSV data from the link).

Now I am trying to get the data from my portal that requires password AND before downloading all data there are 2 functions:

1. that just does select all 

<a id="btnSelectAll" class="important" href="javascript&colon;__doPostBack('ctl00$cphMain$btnSelectAll','')">Select All</a>

and 

2. an export link that executes export of data  to excel ( now this link is more like simple web data pull) 

 

http://imgur.com/9hYhivM

<a id="btnExportAll" class="important" href="javascript&colon;__doPostBack('ctl00$cphMain$btnExportAll','')">Accounts &amp; People</a>

It looks like a 2 step process , ( manualy i log in , go to this page and click on the link selet all accounts, click on the export all accounts and excel is now on my computer-- then i just pick it up with POWER BI and i get a cool updated report in POWER BI) 

Now can we use POWER BI to kinda tell POWER bi TO CLICK CLICK CLICK and automate these 3 steps ? 

@vrossouw  @ImkeF,@MarcelBeug