Forum Discussion
Data blending using multiple data sources
Hi there, Although Power BI can do the data blending using multiple data sources, but it need to import them first before the relationship being defined between different data source. This is not pr...
Yes, you can only import the filtered data because PowerBI does query-folding. So if you join your 2 tables on JoinKind.Inner, this will effectively act as a filter. But watch out: There might still be bugs in it, so you might need a workaround: http://www.thebiccountant.com/2015/09/17/filter-sql-server-queries-with-excel-tables-query-folding-limitations-and-bug-workaround/