Import data from web

[elijah2018]

Hi everyone, 

I am very new to PBI and have been using PBI Desktop for a couple of weeks now. In Desktop it was pretty straight forward to import data from the web by jst providing the URL. 

So wanted to try the web app and see if I could do the same things there as I did in Desktop. 

But the first problem I bumped in to was that I wasnt able to import data from the web right away, I read somewhere thats I needed a on-premise gateway, which I got. 

I added two new datasources to the gateway but when I look under ''Datasets'' I could still not see any of the two datasources I just provided. 

What am I doing wrong ? 

I've been trying using google to find a solution but a most of the links are to Q's and A's about PBI Desktop.

Best regards 

Elijah

[Seth_C_Bauer · Accepted solution]

@elijah2018 The Desktop is your workhorse. This aspect of the tool allows you to do all your ETL and modeling. You publish this to the Service where you share. While the front end report building experiance is shared between the two parts of the tool, the Service is much more the "Sharing" part of the tool and you are limited in what you can do. There are only a few connections you could make from the Service, and you would be really limited if you tried to build everything on it.

The gateway connects the Desktop file to on-premises data sources to refresh what you publish. It doesn't create datasets on its own. The only reason you have to do it in this instance is you are likely using web.contents and they've mandated it with that connection likely due to security.