Power BI sql dataset

[walex]

I have a current Power BI report that was developed my a 3rd party.  The report only brings in some of the sql tables that are in my database.  How do I change the dataset to include all of the tables/views from my sql connection.

[GilbertQ · Accepted solution]

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.

[GilbertQ]

Hi @walex 

Thanks for letting people know!

[v-kaiyue-msft · Accepted solution]

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.

[GilbertQ · Accepted solution]

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.