cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
erikashby
New Member

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 somereason this will not work in PowerBI (Web).

 

OK, so now to step two; Create a gateway and do it locally.  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.

 

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...  How do I connect them up.

 

All the documentation shows how to connect to SQL servers, AD and other sources.

 

Ideas?

4 REPLIES 4
erikashby
New Member

How to use the PowerBI Gateway for WEB (JSON) Content?

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;  (Seems the service has an issue with GetPage used to download from multiple pages)

 

So, I installed the PowerBI Gateway, configured the gateway, created a (WEB) datasource in the PowerBI service, and tested the connection.  ALL WORKS.  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?

 

Does anyone have any reference to how to connect a querty to the datasorce created through the gateway?

Highlighted
Super User III
Super User III

Re: Create a PowerBI Gateway for a Web data load

@erikashby 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?


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
Microsoft v-ljerr-msft
Microsoft

Re: Create a PowerBI Gateway for a Web data load

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.Smiley Happy See How the gateway works.

 

Regards

bryanswan
Regular Visitor

Re: Create a PowerBI Gateway for a Web data load

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.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors