Power BI sql dataset

Hi walex 

You would need to open up the PBIX file and then. go into power query and add the additional tables or views from your SQL connection.

Hi walex ,

I want to acknowledge valuable input provided by GilbertQ . Their initial ideas help guide my approach. However, I noticed that more details are needed to fully understand this issue.

1. In the power query editor, select advanced editor in the added table, you can see the m language it uses, and you can copy it.

2. Select blank query in new source, paste the expression you just copied after the equal sign, and change the table name to the required new table name.

Typically, when you connect to a data source and add multiple tables, each table becomes its own query, so the end result of connecting to the data source again and selecting additional tables will be the same as when you originally connected and selected those tables. I guess it depends on your use case. However, if you edit the query and each table is its own query, this doesn't matter at all.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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