Forum Discussion

jaryszek's avatar
jaryszek
Super User
11 months ago
Solved

Rebinding datasets within import report

Hi Guys,

I want to rebind whole semantic model to OnaLake from my report with import mode. 

I can connect to OneLake semantic Model but this is shown like that: 

 

How to make a transition properly? It is showing DirectQuery to AS which is not what i connected to. I connected to Datalake on OneLake.

 

How to switch semantic model using live connection feature? It is possible? 


Best,
Jacek

 

Need Help
  • Anonymous's avatar
    Anonymous
    11 months ago

    Hi jaryszek,

    Thanks for reaching out to the Microsoft fabric community forum. It looks like the PBIX is pointing at a published semantic model/dataset rather than directly to the Lakehouse files. That is why the data source shows a semantic model entry (DirectQuery to AS) even though you expected a lake connection.

    If you want a Direct Lake (live) semantic model that reads OneLake lakehouse tables, create/open the semantic model from the OneLake catalog in Power BI Desktop, open OneLake catalog -> pick your Lakehouse/Warehouse -> Connect -> name the semantic model, pick workspace, pick tables. That creates/opens a Direct Lake semantic model that is live to OneLake.

    If your goal is to convert an existing Import PBIX into a live-connected PBIX that uses a semantic model from OneLake, note there is no simple single-click “rebind import model to live model” in Desktop. Typical approaches are to first create/open a new PBIX connected live to the target semantic model (via OneLake catalog or Power BI semantic models) and copy pages/visuals from the old PBIX into the new one or, if the report is already published, use the Power BI Rebind REST API to point the published report to a different dataset (requires appropriate permissions).

     

    I would also take a moment to thank lbendlin, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

     

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

    Best Regards,
    Hammad.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    11 months ago

    Hi jaryszek,

    Thanks for reaching out to the Microsoft fabric community forum. It looks like the PBIX is pointing at a published semantic model/dataset rather than directly to the Lakehouse files. That is why the data source shows a semantic model entry (DirectQuery to AS) even though you expected a lake connection.

    If you want a Direct Lake (live) semantic model that reads OneLake lakehouse tables, create/open the semantic model from the OneLake catalog in Power BI Desktop, open OneLake catalog -> pick your Lakehouse/Warehouse -> Connect -> name the semantic model, pick workspace, pick tables. That creates/opens a Direct Lake semantic model that is live to OneLake.

    If your goal is to convert an existing Import PBIX into a live-connected PBIX that uses a semantic model from OneLake, note there is no simple single-click “rebind import model to live model” in Desktop. Typical approaches are to first create/open a new PBIX connected live to the target semantic model (via OneLake catalog or Power BI semantic models) and copy pages/visuals from the old PBIX into the new one or, if the report is already published, use the Power BI Rebind REST API to point the published report to a different dataset (requires appropriate permissions).

     

    I would also take a moment to thank lbendlin, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

     

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

    Best Regards,
    Hammad.