Direct Lake Edit table couldn't fetch warehouse schema.

[Yusuf7]

When trying to edit table in my Direct Lake model, I'm getting the below error.

We could not fetch your warehouse schema An internal error occurred. Please try again later or contact support. 

Activity ID: 412a16bd-f962-4512-abcf-69f8a4a97e8b
Request ID: b192a1cc-9090-4c9b-aec4-34edfcb03b88
Correlation ID: b3c3c9fa-0d39-c06c-cf5d-98fa04b5849c
Status code: 500
Time: Mon May 13 2024 11:16:24 GMT+1000 (Australian Eastern Standard Time)
Service version: 13.0.23263.57
Client version: 2405.1.19178-train
Cluster URI: https://wabi-south-east-asia-b-primary-redirect.analysis.windows.net/

Not sure why this is happening. Have anyone faced the same situation / know the solution?

Regards
TY

[Yusuf7]

Hi

Thanks for getting back on this. The direct lake semantic model was created from a fabric warehouse (not the default semantic model) and only accessible through the web browser.

I've discovered that if I add a field parameter through tabular editor, then this problem happens. In order to access to the Edit Table option again, I need to delete the field parameter table and brng it back after I've added/removed tables from the warehouse.

This to my knowledge, isn't mentioned in the MS documentation so far. 

Can you please check if its possible to accesss to the schema of the semntic model (edit table option without deleting the field parameter?

Thanks 

[Anonymous]

Hi @Yusuf7 ,

Can you please share the steps, how did you added the field parameter?
I will try to repro your issue and can provide some inputs.

Thank you

[Yusuf7]

Hi

I followed steps mentioned in the video below to successfully create field parameters in the direct lake semantic model.

upon creation of the field parameters, the edit table option comes up with the error mentioned, and doesn't correct until all the field parameters are deleted. 

https://youtu.be/Cg6zRhwF-Ro?si=4QhOW54AfuWYrBBi

[Anonymous · Accepted solution]

Hi @Yusuf7 ,

Thanks for sharing the link. I watched the video and can find this point - click here 

As he said - "we can no longer open and edit this model using model view in web browser".

Hope this helps. Do let me know incase of further queries.

[Anonymous]

Hi @Yusuf7 ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks

[Yusuf7]

Hi

Thanks for the clarification. I hav missed that part in the video. I'm accepting this as a slution. I hope MS will include field parameters natively in direct lake in the coming months. 

[Anonymous]

Hi @Yusuf7 ,

Glad to know that your query got resolved. Please continue using Fabric Community on your further queries.

Appreciate if you could share the feedback on our feedback channel. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

[Anonymous]

Hi @Yusuf7 ,

Thanks for using Fabric Community.
Apologies for the delay in reply from our side. Did you got a resolution for this?
Can you please confirm whether you are trying to edit the Direct Lake Semantic model using PowerBI Desktop (Application) or Chrome (Web Browser)?

If you can provide these details, I would be able to guide you better.