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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
PaulKraemer
New Member

Power BI Desktop - how to add additional tables from a Data Source I already defined?

Hi,

 

I just started using Power BI Desktop. By clicking Get Data in the Data Group on the Home Tab, I was able to pull in Data from an ODBC data source I have defined on my PC (Windows 10 Pro). When I did this, I was able to choose any of the tables that exist in this data source, but I only chose one table.

 

Now I would like to add additional tables from this same data source, but it is not clear to me how I can do this.

 

If anyone here can tell me how I can modify a Data Source that I already defined in Power BI Desktop by adding tables I did not include initially, I would greatly appreciate it.

 

Thanks in advance,
Paul

1 ACCEPTED SOLUTION
rajendraongole1
Super User
Super User

Hi @PaulKraemer - Go to Transform Data > Transform Data (this opens the Power Query Editor).

In the Power Query Editor, you can choose New Source and select the same ODBC connection to bring in additional tables.

From here, you can apply transformations, such as filtering or renaming columns, before loading the data.

Resolved:

Solved: Adding in new tables from same datasource - Microsoft Fabric Community

Solved: Add more tables from same datasource - Microsoft Fabric Community

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

2 REPLIES 2
rajendraongole1
Super User
Super User

Hi @PaulKraemer - Go to Transform Data > Transform Data (this opens the Power Query Editor).

In the Power Query Editor, you can choose New Source and select the same ODBC connection to bring in additional tables.

From here, you can apply transformations, such as filtering or renaming columns, before loading the data.

Resolved:

Solved: Adding in new tables from same datasource - Microsoft Fabric Community

Solved: Add more tables from same datasource - Microsoft Fabric Community

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Thank you Rajendra - that worked perfectly !

 

I appreciate your help!

 

Best regards,
Paul

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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