Forum Discussion
Include additional table or query result using existing DB source
Hi AndrewP,
With Import mode, when you choose n-tables and refresh, PBI will generate separate n-queries to your source as SQL queries. So when you want to add 2 more tables after added 2 tables, you just choose get data/recent sources and select 2 additional tables. Is this your concern?
No.
When I started I created a new database source and selected specific tables.
I would like to modify that to include more tables.
How can I do that, and ONLY that?
(Recent sources is empty)
Hi AndrewP,
I got your point now, your expectation could be and could not ^_^
- if your sources are SQL DB, you have no way to open the select list dialog and tick or untick. (so you have to choose recent sources/get data to add another tables)
- if your sources are CUBE (SSAS Cube), go to Edit Queries, choose the query in left navigation panel, and double click Added Item in Query Setting panel in the right. Now you could select more dim/facts (it's dim or fact, not table)
tringuyenminh92 wrote:Hi AndrewP,
I got your point now, your expectation could be and could not ^_^
- if your sources are SQL DB, you have no way to open the select list dialog and tick or untick. (so you have to choose recent sources/get data to add another tables)
My source is MySQL. The data is there, and refreshes ok, so I know the source exists, but recent sources is blank/empty.Hi AndrewP,
So please use Get Data, and in the fill in dialog, please enter both server and database name (even thought database name is optional). Hope it works.
tringuyenminh92 wrote:Hi AndrewP,
So please use Get Data, and in the fill in dialog, please enter both server and database name (even thought database name is optional). Hope it works.
That's exactly what I do NOT want to do.
I have done that in the past and then I end up with multiple sources.
That's exactly what I'm trying to avoid.