Create a PowerBI Gateway for a Web data load

Question

I created a Power BI query using the PowerBI desktop to downlaod data through a web API. &nbsp;The problem is that my query uses (getpage) since the data requires mutliple pages to downlaod and for somereason this will not work in PowerBI (Web).&nbsp;OK, so now to step two; Create a gateway and do it locally. &nbsp;After installing the gateway, I cannot find ANY instructions for how I can connect my query that I create in PowerBI desktop to the gateway instance and the data-source that I created in the cloud so that I can schedule a refresh.&nbsp;The gateway is configured, a (WEB) datasource is created in PowerBI (cloud), and is validated, and I have a (WEB) Query in my local PowerBI Desktop that works great... &nbsp;How do I connect them up.&nbsp;All the documentation shows how to connect to SQL servers, AD and other sources.&nbsp;Ideas?

bryanswan · Answer

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.

erikashby · Answer

I created a local PowerBI query in my desktop that works great to pull down results from a web API that requires paging, howerver when publishing to PowerBI the query cannot be refreshed; &nbsp;(Seems the service has an issue with GetPage used to download from multiple pages)&nbsp;So, I installed the PowerBI Gateway, configured the gateway, created a (WEB) datasource in the PowerBI service, and tested the connection. &nbsp;ALL WORKS. &nbsp;Now I cannot find any references to how to connect the Query that I crated in PowerBI desktop to the Datasource that I created through the gateway?&nbsp;Does anyone have any reference to how to connect a querty to the datasorce created through the gateway?

anonymous · Answer

erikashby&nbsp;As long as the data source matches, you can just publish the report to the Service and be able to refresh... Is this what you are asking?

v-ljerr-msft · Answer

Hi&nbsp;erikashby,&nbsp;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&nbsp;a refresh for your dataset as long as the datasource matches like&nbsp;Eno1978 said.:smileyhappy: See How the gateway works.&nbsp;Regards

Forum Discussion

Related content

Gateway powerBI

powerbi gateway service

Configuration of PowerBI Gateway fails

PowerBI Gateway ODBC Connection

Create Gateway Connection - API