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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.