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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
smpa01
Super User
Super User

Adding new table source data in Power BI VSCode

I currently have this with with `EDIT TMDL` in powerbi-vscode 

smpa01_0-1710971260158.png

Is it possible to add another table 'fact' in tables as fact.tmdl where the pq is

let
    Source = Sql.Database("server", "db", [Query="
    SELECT TOP 1000 *
    FROM tbl
    "])
in
    Source

Cause once I publish and validate the TMDL, the pbi is not downloadable. Is there a way to do it from here?

@gbrueckl

 

Thank you in advance

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
1 REPLY 1
v-weiyan1-msft
Community Support
Community Support

Hi @smpa01 ,

 

Based on the information you provided, it appears that you are trying to add new tables to your Power BI model using the Table Model Definition Language (TMDL) in PowerBI-VSCode .
After reviewing the version release notes for the VSCode extension, I could not find specific information about the functionality you are looking for.

vweiyan1msft_0-1711011071617.png

For a more accurate answer, it is recommended that you contact the developer of the extension.
In addition, you can refer to the following article about TMDL:

Tabular Model Definition Language (TMDL) | Microsoft Learn


Best Regards,
Yulia Yan


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

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