Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
@miguel - Do you have any guidance/suggestions? We've been struggling to get anything working with DFG2 since Fabric was announced. We're not doing anything crazy - just trying to move relatively small tables from on-prem SQL Server to a warehouse. No transformations at all.
We've gone through many different error messages, but the latest one that consistently comes up is below. We've had a support ticket open since November, but they've been bouncing it back and forth and nothing has happened. Our trial is running out and we can't afford to keep trying these on our paid capacity and affect production workloads.
104100 Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Web.Contents failed to get contents from 'https://wabi-us-west2-redirect.analysis.windows.net/v1/workspaces' (429): Details: Reason = DataSource.Error;DataSourceKind = Warehouse;DataSourcePath = Warehouse;Url = https://wabi-us-west2-redirect.analysis.windows.net/v1/workspaces;Microsoft.Data.Mashup.Error.Contex... = User GatewayObjectId: 0ff40ade-06f0-4614-be67-a7bc67c40db8
We are uploading bits for the fix to Download Center, the version is 3000.210.14 - if you go to this version the 429 problem mentioned in this post should be fixed.
I'm happy to report that everything is working well now! It actually resolved itself before updating to the latest gateway. Thanks @pqian_MSFT for the assist!
Hi @Joshrodgers123 ,
Glad to know that your issue got resolved. Please continue using Fabric Community for your further queries.
I have support ticket created for similar problem. Totaly random CU usage for any of dataflows. They are all ran one after another, initiated in pipeline. 100 000 rows refresh can take 1 minute and consume ~2000CU's, and then another dataflow with 40 000 rows goes for 30mins and consumes 50 000CU's. And that happens totaly random, it can be one or few dataflows, any of them with no matter how many rows. Also this happens with no transformations in dataflow, or for the ones with one filter (wich is folded to SQL). I am waiting for on premise gateway support for pipelines and will try to avoid dataflows as much as possible.
Hi!
A couple of suggestions:
Thanks @miguel. I'll circle back at the end of the week if the issue persists. As of this morning, it still does and it looks like the workspace/429 error you are describing.
As far as repro, all we are doing is loading a few tables from an on-prem SQL server to a warehouse (replace). No additional transformations steps. Largest tables are ~100k rows, but even tables with 20 rows are failing.
Gateway is up to date on version 3000.202.16. I know the download page shows 3000.210.16, but when you click download it gives you 3000.202.16.
Are you able to repro this behavior in a different workspace?
Hi @miguel - yes, this is occuring in a few workspaces. The issue still occurs as of 10 minutes ago. Support has not been able to figure anything out yet.
This is the error I am seeing most of the time:
104100 Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Web.Contents failed to get contents from 'https://wabi-us-west2-redirect.analysis.windows.net/v1/workspaces' (429): Details: Reason = DataSource.Error;DataSourceKind = Warehouse;DataSourcePath = Warehouse;Url = https://wabi-us-west2-redirect.analysis.windows.net/v1/workspaces;Microsoft.Data.Mashup.Error.Contex... = User GatewayObjectId:
Request ID: 5f4a2d42-2483-4b1b-a46b-ec9bd4746bec
Dataflow ID: 9643b30d-5655-450a-a5e3-d942804805a4
Session ID: e79b282a-18a8-f682-a60c-07f88e2dffeb
I will say it has gotten better this week. Last week and the previous few months it would fail 90% of the time. It's probably failing 25% of the time this week.
We investigated this offline with @Joshrodgers123
There is a fix that will be included in a new gateway version. We'll get it published ASAP.
Hello, please give us update when it this fix will be available, to update gateway. I also have dataflows issues, hoping this will solve mine too
User | Count |
---|---|
5 | |
4 | |
3 | |
3 | |
2 |