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
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
Solved! Go to Solution.
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
Proud to be a 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
Proud to be a Super User! | |
Thank you Rajendra - that worked perfectly !
I appreciate your help!
Best regards,
Paul
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
108 | |
102 | |
94 | |
71 |
User | Count |
---|---|
173 | |
134 | |
132 | |
102 | |
95 |