cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Power BI Team dimazaid
Power BI Team

Updates to the Web connector

We are currently working on improving the refresh of cloud based data sources. As part of this, one of the changes we have made recently is that new datasets that leverage import from Web pages will not be automatically configured for refresh in Power BI service, and will require the use of a gateway. Please consider using the Personal Gateway or On-Premises data gateway if you would like to use this capability. We are working on removing this restriction in the future.


Thanks,

The Power BI team

69 REPLIES 69
kaushal Frequent Visitor
Frequent Visitor

Re: Updates to the Web connector

Does this mean if I have used URL as a datasource, then in powerBI service, I cannot use schedule refresh to connect directly and I need to have a gateway which will be used to load data from the URL?

TBenders Regular Visitor
Regular Visitor

Re: Updates to the Web connector

Jepp.

 

@dimazaid I spent hours trying to figure out why I couldn't refresh my web-data sources without a gateway, because the official documentation still says the gateway is not needed. 

https://powerbi.microsoft.com/en-us/documentation/powerbi-personal-gateway/

kaushal Frequent Visitor
Frequent Visitor

Re: Updates to the Web connector

But I am still able to refresh some of the new datasets without gateway where I have used Web as datasource.

Re: Updates to the Web connector

I have case with using url https://onedrive.live.com/download. In PowerBI Desktop it works, on PowerBI Service it does not (it gives me no credentials message). Onedrive is personal version, and link is for anonymous connect.

Power BI Team faisalmo
Power BI Team

Re: Updates to the Web connector

As far as I know, this only affects any "screen scraping" you are doing; so if your queries contain "Web.Page", then you will need to follow the advice here. We have plenty of data sources that are accessed via http / web and that's not going to be affected. E.d. OData.Feed, Web.Contents, etc. will all be unaffected.

Re: Updates to the Web connector

Hmmm, I have no scraping stuff. I have two workbooks and pbix file on personal onedrive. Pbix file was imported into PowerBI service (free) using GET DATA, and Pbix file as source targeted those two excel workbooks on onedrive via https://onedrive.live.com/download... links.

All this worked before on PowerBI service, and still works on PowerBI Desktop, but now I get errors about credentials or it spins while auhorisation of web credentials.

Any idea?

Power BI Team faisalmo
Power BI Team

Re: Updates to the Web connector

OK - there is another issue that affects data connectivity to OneDrive / Sharepoint that you are probably running into. That is being addressed at the moment. This is different from the Web page import issue.

 

Stay tuned. 

 

-faisal

Re: Updates to the Web connector

Thanks @faisalmo

Power BI Team dimazaid
Power BI Team

Re: Updates to the Web connector

hi @TBenders,
We applogize for the confusion, the documention should be updated in the next few days. 

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 150 members 2,320 guests
Please welcome our newest community members: