I have 3 excel files each around 56896 KB. Users use the data in excel for some reference. Now they use the Excel Manually, since Excel has exceeded its size, when they search it hangs up. What is the best approach to load them in SQL database. Note: every month I get set of 3 files that should be updated. 1. I can create a table to insert the data from 2 files and bring it SSRS Report to access to Users. 2. Can I use Tabular mode in SSAS. I have never created Tabular mode. Not sure whether My need will be satisfied if we use Tabular.
I am new to SSAS. please help on