Forum Discussion
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.
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.
What about Excel files on OneDrive "Excel.Workbook(Web.Contents)"?
I have an open support ticket on a project with this type of connection and the supporter keeps insisting that it is a Gateway related error although the solution only contains online sources.
Frustration!!
You are making it very hard for us to sell and implement Power BI when it is this unstable and your Gateway fix is unacceptable. You need to stabilize this product, bridge the gaps and make it Enterprise ready. The IT departments don’t like Gateways and it doesn’t make sense to add a gateway for an online source!
You had a god thing going, but the last month or so with extremely unstable service has damaged Power BI and this “feature cut” has only made it worse. Please consider that we have solutions running in production.
jeppesal is right.
If there are connection only to cloud / online services - it doesn't make any sense to install a Gateway.
Guys, common, you can do better - please make the refresh stable - currently all Power BI projects are NO GO because of this.
Thanks!
Michael
Anonymous, thanks for the feedback. We're looking working on this and hoping to get your project soon.
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?
I am facing the same issue
1. used web connector to connect to excel on onedrive for business
2. suto schedule is not working
but when i try to use a gateway (just like it is suggested) it still gives me an error. Under the gateway there is no "oauth" option and using the basic, anonomus, and windows still gives me an error.
Can I can now refresh my report which is conneted to excel on ODFB?
Hi Anonymous,
The error you're running into is due to a different issue. The good news is that the fix should be in PROD soon, stay tuned, I'll post a comment here once it's online.
Thanks!
Dimah
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
Thanks faisalmo
