Can I .. ? Have a surrogate key to a wide (800 columns 200 million rows +) dataset. Use surrogate key + 20-40 more columns to build a cube .
Can I .. ? Have a surrogate key to a wide (800 columns 200 millions rows +) dataset. Use surrogate key + 20-40 more columns to build a cube and have PowerBI be the interface, narrow down by dates, areas, amounts and many other dimensions. When the customer likes what they narrowed down to I want to retrieve the ids (surrogate keys) that makes that selection and deliver much more in depth non aggregate data (800+ columns and we may join to other table to get more rows etc, a much larger in some cases 200GB+ text files we deliver). Can I use PowerUi as it's perfect for presentation to narrow the data and I retrieve the surrogate keys of that selection (could be many million keys) , get the keys into sql server and do further deliveries to clients?