Forum Discussion
Import data from SSAS Tabular model
I think I may have found a workaround. You connect to AS and when you can choose which tables to load, you only choose one table. You load it (or edit first and then load) and then you connect again to AS via Get Data and choose another table, and so on, until all the tables needed are imported.
But for my case, I think DirectQuery is the better connection option.
Hope this helps!
Anonymous Thanks for the help! I like your workaround comment. Helped me a lot!
Shelley since my comment, there has been quite a lot of Power BI advancements, so I do not see the need to import from AAS model anymore. We wanted to import so that we can add more data sources directly in the Power BI desktop model. But the new composite models feature that works with AAS models is fixing this issue. An extra note Shelley, opening to import for users can put big strains on your AAS Server when they refresh the data (and you have no control over this), so it can disrupt your normal DQ model. I am unsure what your case is, but I would advise against using import on AAS models