Can we Join normal data source tables with "Append data source"?

Unfortunately, it is not possible to join the tables to the append data source in Bold BI. Append data source allows you to merge data from various tables using a UNION ALL operation. However, if you require establishing connections between tables from different data sources, you can utilize joins like inner join, left join, right join, full outer join, or cross join.

Additional References

• Bold BI append data source
• Bold BI table joins
• Shared Table in Bold BI
• Understanding SQL Joins