topic Re: Internal error when using Visual Query in Warehouse for views in Data Warehouse

Internal error when using Visual Query in Warehouse for views

charrington — Fri, 03 Nov 2023 19:44:57 GMT

I am using the new visual query tool and it's great!
I have created views in my Warehouse, and I'd like to use them in the Visual query, but I get some error.

It's most likely not supported, but I wanted to check with you. A view returns data, like a table or shortucut...why can't it be used in Visual queries?

I get this error:
Underlying Error: TypeError: Cannot read properties of undefined (reading 'name')
Activity ID: 61786aeb-0d2c-424e-98c3-1a9396af5ed8
Correlation ID: 1677352d-c035-fc46-8a0f-dbd5b060fe4a
Request ID: d6a37f2c-7b73-8d3d-6c9c-335d841fe027
Time: Fri Nov 03 2023 15:36:52 GMT-0400 (Eastern Daylight Time)
Service version: 13.0.21891.85
Client version: 2310.4.16370-train
Cluster URI: https://wabi-south-central-us-redirect.analysis.windows.net/

Thanks

Re: Internal error when using Visual Query in Warehouse for views

Anonymous — Fri, 03 Nov 2023 20:20:13 GMT

Hi charrington ,
Thanks for using Fabric community.

We are reaching out to the internal team to get more information related to your query and will get back to you as soon as we have an update.

Re: Internal error when using Visual Query in Warehouse for views

Anonymous — Wed, 15 Nov 2023 18:52:02 GMT

Hi charrington
Apologies for the delay in response. The internal team has confirmed that there is an ongoing bug related to this issue. Currently there is no ETA by when this gets fixed.
I will keep you posted regarding the updates. Appreciate your patience.

Hope this helps. Please let me know if you have any further questions. Glad to help.

Re: Internal error when using Visual Query in Warehouse for views

Anonymous — Mon, 20 Nov 2023 06:25:50 GMT

Hi charrington
We haven’t heard from you on the last response and was just checking back to see if you got some insights regarding the issue. Please let us know if you have any further queries.

Re: Internal error when using Visual Query in Warehouse for views

Anonymous — Tue, 21 Nov 2023 04:01:15 GMT

Hi charrington
We haven’t heard from you on the last response and was just checking back to see if you got some insights regarding the query.
Otherwise, will respond back with the more details and we will try to help.
Thanks

Re: Internal error when using Visual Query in Warehouse for views

charrington — Tue, 21 Nov 2023 14:59:06 GMT

Hi
I don't get the error anymore, but I still cannot drag a view to the visual query, nothing happens when I do it.

So this is not working as expected, I should be able to to use views also on the visual query.
thanks