Forum Discussion
Problems with SSAS Live Connection
I am not sure about the VPN bit, but if you are using an SSAS database in live connetion mode in power bi you will not be able to create measures, etc. When you use SSAS all you can really do is create visuals because its expected that the data is fully modelling the way you want it. If you need to enhance the model use Import mode.
If have flexibilty you can set up the roles in SSAS in live mode, if you import though you can use Row Level Security to manage roles.
Thank you for sharing your valuable feedback. I have a question based on your revert. Without any measure group, how can we process the cube first? I had a word with Microsoft team, they informed us after 2 days validation, the problem arises from SSAS server, not BI. You need to contact ssas team.
If the same cube process using import mode then its publish and visible in the live BI server without any disturbance. Can anyone there to give us the proper way to publish the online cube.
