cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
erikashby Frequent Visitor
Frequent Visitor

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 Frequent Visitor
Frequent Visitor

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?

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

Highlighted
bryanswan Frequent Visitor
Frequent 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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors