Please refer to this https://microsoftlearning.github.io/mslearn-fabric/Instructions/Labs/01-lakehouse.html At step Create a visual query, I have saved as view my final query. now when I am creating a model it's not listing there while when I create report, I can see my table and view both. but now how can I make relationship between table and view on report.

Hi Yogendra Bhardwaj , Thank you for your patience. After creation of visual query and saving it as a view and before going to the Model tab kindly ensure to refresh the page for visibility of view created. We have replicated the scenario from our end and were successful in creating the relationship between table and query. Kindly check the below attachments for step-by-step process for your reference. Step 1: To Create the View: Step 2: Created as Visualquery1: Note: Before going to Model tab, kindly refresh the page. Step 3: We can see all the listed tables and views in Model tab: Step 4: Create the relationship between table and view: If the information is helpful, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post. If you are still running into issues, kindly attach the screenshots for reference and please let us know in the comments. We are glad to help you. (NOTE: Please conceal all your privacy details before posting). Thank you.

Fabric - Relationship between SQL query column and table column

Accepted answer

pnaroju 1,555 Reputation points Microsoft Vendor

2024-02-26T08:40:27.1366667+00:00

Hi Yogendra Bhardwaj,

Thank you for your patience.

After creation of visual query and saving it as a view and before going to the Model tab kindly ensure to refresh the page for visibility of view created.

We have replicated the scenario from our end and were successful in creating the relationship between table and query.

Kindly check the below attachments for step-by-step process for your reference.

Step 1: To Create the View:

Step 2: Created as Visualquery1:

Note: Before going to Model tab, kindly refresh the page.

Step 3: We can see all the listed tables and views in Model tab:

Step 4: Create the relationship between table and view:

If the information is helpful, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post.

If you are still running into issues, kindly attach the screenshots for reference and please let us know in the comments. We are glad to help you.

(NOTE: Please conceal all your privacy details before posting).

Thank you.
Please sign in to rate this answer.
Yogendra Bhardwaj 20 Reputation points

2024-02-27T03:56:29.74+00:00

Thanks for quick response and i was able to reach till last step but when saving my changes, getting this error message.

Underlying Error{"code":"ExternalServiceFailed","pbi.error":{"code":"ExternalServiceFailed","parameters":{},"details":[{"code":"ModelingServiceError_Reason","detail":{"type":1,"value":"An internal error occurred."}},{"code":"ModelingServiceError_Location","detail":{"type":1,"value":"Datamart Workload"}},{"code":"ModelingServiceError_ExceptionType","detail":{"type":1,"value":"DatamartServerException"}},{"code":"ModelingServiceError_Message","detail":{"type":1,"value":"An internal error occurred."}},{"code":"ModelingServiceError_ExceptionErrorCode","detail":{"type":1,"value":"InternalError"}}]}}

Activity ID65d54e45-eaf3-485a-8116-4ef1944dc7eb

Correlation ID4cd5c3a8-bc8a-a76b-8f49-1560f6e487d0

Request ID10dbc639-cfae-043a-2c41-dfdc17a6b161

Status code500

TimeMon Feb 26 2024 22:53:22 GMT-0500 (Eastern Standard Time)

Service version13.0.22729.74

Client version2402.3.18145-train

Cluster URIhttps://wabi-us-north-central-redirect.analysis.windows.net/

pnaroju 1,555 Reputation points Microsoft Vendor

2024-02-27T07:31:20.02+00:00

Hi Yogendra Bhardwaj,

Could you please confirm whether you have utilized an SQL query or a visual query to create a view. Additionally, could you please provide the details of the query for further clarification?

Upon replicating the scenario from our end, we were able to successfully establish the relationship between the table and the query without encountering any issues.

As per the error message and as a suggested workaround, we recommend attempting the operation again after some time by refreshing the page. Furthermore, we suggest creating a new view from a new query and establishing a relationship between the table and the new view. This approach might resolve the issue you are facing.

If you find this information helpful, we kindly request that you accept the answer by clicking the "Upvote" and "Accept Answer" options on the post.

Should you continue to experience difficulties, please consider attaching screenshots for reference, ensuring that all privacy details are concealed. Please inform us in the comments section, and we will be pleased to assist you further.

Thank you.

pnaroju 1,555 Reputation points Microsoft Vendor

2024-02-28T06:49:14.1666667+00:00

Hi Yogendra Bhardwaj,

We are really glad to know that the issue is resolved for you.

If the issue persists, please contact us, and we'll be happy to assist you further.

Thank you.
Sign in to comment

Share via

Fabric - Relationship between SQL query column and table column

0 additional answers