Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
pmscorca
Post Patron
Post Patron

How adding a new warehouse table/view to an existing custom Power BI semantic model in Fabric

Hi,

in Fabric I've tried to use the available options to add a new warehouse table/view to an existing custom Power BI semantic model, in order to update the related Power BI report. A such operation it doesn't seem very simple.

Any helps to me, please? Thanks

5 REPLIES 5
tharunkumarRTK
Super User
Super User

@pmscorca 

Assuming your custom semantic model is in direct lake mode.

If you want to add new tables/views from warehouse to an existing custom semantic model, then follow these steps

1. Enable edit data model in power bi service option in workspace settings

Screenshot 2024-07-20 at 10.51.35 PM.png

2. Hover over the dataset and click on three dots and click on 'Open data model' 
Screenshot 2024-07-20 at 10.53.17 PM.png

3. You will find an option to manage tables, click on it and you will find all the tables avaraible in the warehosue select the tables/view and click on confirm. thats it

Screenshot 2024-07-20 at 10.57.21 PM.png

 

if the storage mode is import then I would suggest you to open the pbix file form power bi desktop and add the new tables/view by connecting to the warehosue directly.

 



Need Power BI consultation, hire me on UpWork .


If the post helps please give a thumbs up



If it solves your issue, please accept it as the solution to help the other members find it more quickly.




Tharun



Hi,

the Power BI option is already checked:

pmscorca_0-1721498962584.png

When I select the existing custom semantic model and the Open data model option I cannot see any Edit tables voice in the menù. Thanks

@pmscorca 

 

As I mentioned in my previous response, if the storage mode of you tables is not direct lake then you will not be able add new tables from service. Just check the storage mode from advances settings 

Screenshot 2024-07-20 at 11.50.42 PM.png

for import mode datasets, open the pbix file from desktop and add new tables by connecting to the warehosue.

 



Need Power BI consultation, hire me on UpWork .


If the post helps please give a thumbs up



If it solves your issue, please accept it as the solution to help the other members find it more quickly.




Tharun



Hi, the storage mode is import.

In Fabric, does it occur to use the PBI desktop to edit a PBI semantic model, yet?

It depends on how you published your model into power bi service. If you dont the pbix file then download it from power bi service and then add the tables. If it is not possible then use tabular editor and add the tables and push the changes.

 



Need Power BI consultation, hire me on UpWork .


If the post helps please give a thumbs up



If it solves your issue, please accept it as the solution to help the other members find it more quickly.




Tharun



Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.