Be careful to SSAS caching
We take the following scheme in Power BI
below are a screen shots illustrating what’s going (using sql profiler) when creating a simple report query in Power BI
observe that the (select *) behavior that occurs on all subqueries (even if one column was requested in a report query). The the select * is an intentional SSAS decision to take advantage of caching. If the data volumes are big, the cache never live long so it is a detriment rather than a help.
Shows the statement (select *) is even worse for a snowflake design as it traverses every table with a (select *) to take to the category name in the product table: