Hi,
I have a database in a SQL-server with 8 million rows and +50 columns. I want to be able to filter what data Excel imports, such that it does not load all 8 million rows. In particular I want to be able to filter in an Excel workbook by clicking the things I want to import. As an example I have tried to first select the columns I want to be able to filter by in a Power Query, taking only distinct rows then loading them into Excel, created slicers on this table, loaded it back into Power Query selecting only the rows left after choosing in the slicers and used this for input in a new Power Query that would be the one to import my main data but it is either a really slow approach and sometimes it do not work - it just says "Connecting to source". Any suggestions?
Thanks in advance!
I have a database in a SQL-server with 8 million rows and +50 columns. I want to be able to filter what data Excel imports, such that it does not load all 8 million rows. In particular I want to be able to filter in an Excel workbook by clicking the things I want to import. As an example I have tried to first select the columns I want to be able to filter by in a Power Query, taking only distinct rows then loading them into Excel, created slicers on this table, loaded it back into Power Query selecting only the rows left after choosing in the slicers and used this for input in a new Power Query that would be the one to import my main data but it is either a really slow approach and sometimes it do not work - it just says "Connecting to source". Any suggestions?
Thanks in advance!
