Forum Discussion

Oliver_Buchanan's avatar
Oliver_Buchanan
Helper I
14 days ago
Solved

Semantic model relationship window scroll bar missing

It's just gone.   I've tried different browsers, incognito, refreshing the semantic model, refreshing the table schema. I can't open in desktop either it gives me an error "Object reference not set...
Need Help
  • tharunkumarRTK's avatar
    tharunkumarRTK
    14 days ago

    Oliver_Buchanan​ 

    I am assuming your semantic model is a direct lake semantic model. If yes then you should be able to edit the semantic model from Power BI desktop, please check if you are following the right steps

    Live edit of Direct Lake models in Power BI Desktop | Microsoft Fabric Community

    For the issue you are facing I have one workaround, which you can follow till the time the issue is resolved.

    1. In the new relationship window, after selecting From Table and To Table, select random columns which are accessible to you.
    2. Once the relation is created, On the right hand 'Data' pane toggle to 'Model' View.
    3. Expand 'Relationships'
    4. Select the relation you just created 
    5. Properties pane will appear on the left, expand it.
    6. There you would be able to select the appropriate column from the vertical drop down.
    7. Change the other properties of the relation. 
    8. Repeat the same for other relationships as well

    I understand that this workaround involves multiple clicks. But this will work.

     

tharunkumarRTK's avatar
tharunkumarRTK
Super User
14 days ago

Oliver_Buchanan​ 

I am assuming your semantic model is a direct lake semantic model. If yes then you should be able to edit the semantic model from Power BI desktop, please check if you are following the right steps

Live edit of Direct Lake models in Power BI Desktop | Microsoft Fabric Community

For the issue you are facing I have one workaround, which you can follow till the time the issue is resolved.

  1. In the new relationship window, after selecting From Table and To Table, select random columns which are accessible to you.
  2. Once the relation is created, On the right hand 'Data' pane toggle to 'Model' View.
  3. Expand 'Relationships'
  4. Select the relation you just created 
  5. Properties pane will appear on the left, expand it.
  6. There you would be able to select the appropriate column from the vertical drop down.
  7. Change the other properties of the relation. 
  8. Repeat the same for other relationships as well

I understand that this workaround involves multiple clicks. But this will work.

 

  • Oliver_Buchanan's avatar
    Oliver_Buchanan
    Helper I
    13 days ago

    Thanks, i've raised a separate bug directly with Microsoft on the semantic model not opening in desktop.

    The work around above works thanks so i'll mark as a solution. though annoying that the scroll bar is gone.