Forum Discussion

joakimfenno's avatar
joakimfenno
Icon for Helper V rankHelper V
2 years ago
Solved

Fabric - semantic model - refresh

I just started with semantic models in fabric What is the best way to resync a table a table from the source (i.e add a new column to a table in the model that has been added to the source table). ...
Warehouse
  • joakimfenno's avatar
    joakimfenno
    1 year ago

    I found the issue

    I had one view in the warehouse with two columns having identical names where one of them had a capital letter

    I tried to refresh the warehouse from fabric gui and received the duplicate column name error message

    It is fully possible (at least from sql endpoint) to create a view with two columns names aa and Aa for example. However its not supported in semantic models and semabtic model will not give you an indication of this issue 

frithjof_v's avatar
frithjof_v
Icon for Community Champion rankCommunity Champion
1 year ago

I don't have experience with it, but I think scroll down to Power BI -> Get customer support https://support.fabric.microsoft.com

 

I think you should also check with IT / Microsoft 365 Admin in your organization to see if you have some special considerations regarding support tickets, how much data you can share with the MS support personnel, etc.

 

I think the issue you are encountering is a known issue and current workarounds seem to be to use Tabular Editor or Power BI Desktop (import mode).

joakimfenno's avatar
joakimfenno
Icon for Helper V rankHelper V
1 year ago

thanks

 

Import mode works but I need to create a general model that van be used for mutiplöe reports and be consumed directly from excel. Can you acheive this with Power BI Desktop?
regarding tabular editor - can ypou publish a semantic model or a general model from that tool?

  • frithjof_v's avatar
    frithjof_v
    Icon for Community Champion rankCommunity Champion
    1 year ago

    I think any semantic model is a general model.

     

    You can create multiple reports with live connection to any semantic model.

     

    I also think you can connect Excel to any semantic model.

     

    This is possible for Power BI Desktop (import mode) semantic models, but the semantic model needs to be published to the web service before you can create new reports connected to the model or connect to the model from Excel.

     

    Here's how to do it: you create a model (actually you need to create a report) in Power BI desktop, then you publish this report with it's model to the web service. This way the model becomes available to create other reports connected to this model, or connect to the model from Excel.

     

    Obviously, there are sharing and governance questions regarding this, so be sure to read up on and understand topics like sharing of power bi models/reports, power bi access control and permissions, analyze in excel.

     

    With tabular editor you can also create, edit and publish a semantic model. It can not be used to create a report.

     

    Power BI desktop is used for creating report+model. It's not possible to create a model without report in Power BI desktop. So you will need to create a report (it could be empty) and it means you create a model at the same time. This is a bit unintuitive. However in order to create a model in Power BI desktop, you will need to create a report (it could be blank). When you publish the Power BI Desktop report+model to the web service, other reports and Excel can connect to the model which is hosted in the web service. I think Power BI desktop is a quite easy tool to use.