Forum Discussion
How to link my 4 table source field ?
Hi All
When I try to link the SOURCE field of 4 table I get multiple relationship. May I know how should I link ?
Paul
Hi, Anonymous
It’s my pleasure to answer for you.
According to your description,You appended two tables into a single table ,if you use first option,it will only get one table,if you use second table,you can turn off the enable load button for the original tables.
If you publish the report to PBI service, you need to configure all data sources in the gateway.
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- mahoneypat
Microsoft Employee
If those pairs of tables are the same except for the Source (Thailand vs. Singapore), they should each be appended in the query editor. You will end up with 5 tables total. This will greatly simplify your model for analysis/visualization. If needed, you can add a fixed column called Source to each table with the appropriate name (e.g., "Thailand") prior to the append steps so you have a new column to use in a slicer, legend, etc. After you append, you can right click on the source queries and uncheck Enable Load, so that only the final tables are loading into your model.
Regards,
Pat
- v-janeyg-msft
Community Support
Hi, Anonymous
It’s my pleasure to answer for you.
According to your description,You appended two tables into a single table ,if you use first option,it will only get one table,if you use second table,you can turn off the enable load button for the original tables.
If you publish the report to PBI service, you need to configure all data sources in the gateway.
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Jane
Thank you for your sharing , i will take note of what you mentioned about append. By the way Amit today have provide me with the solution , now all table SOURCE Is abl to link and beside that sales and target also working fine.
For Sales and Table link , i must thank Robert help for create a bridge.
Paul
