Forum Discussion

erikashby's avatar
erikashby
New Member
9 years ago

Create a PowerBI Gateway for a Web data load

I created a Power BI query using the PowerBI desktop to downlaod data through a web API.  The problem is that my query uses (getpage) since the data requires mutliple pages to downlaod and for somere...
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi erikashby,

 

As you have installed and configured the gateway, and added the datasource to it in Power BI Service, you just need to publish your report from Desktop to Service, then you should be able to schedule a refresh for your dataset as long as the datasource matches like Eno1978 said.:smileyhappy: See How the gateway works.

 

Regards

bryanswan's avatar
bryanswan
Advocate I
9 years ago

This is not exactly accurate, his question is regarding publishing Power BI workbooks whose data source is from JSON, so no refreshes are happening on a local SQL Server etc. His question is why cannot these dashboards be allowed to refresh in the same fashion and not be predicated on a gateway in the first place as the data is web based. This is a rather serious incongruency in the architecture, as the strongest feature of Power BI compared to its competitors are the robust XML and JSON (now part of Tableau) and Web Data pulls.