0

I've moustly exactly complete steps, described in this post, except that I'm training in northeurope datacenter.

But after succesful deploying model to azure AS I cannot access it with powerBI. It connects to service, but cannot found any models in it.

I suppose it may be some permission problem. But while composing model, I can add to project roles only my local user accounts, nor microsoft id's nor azure active directory user.

How it can be done?

GregGalloway
  • 11,355
  • 3
  • 16
  • 47
Dmitry Ponkratenko
  • 33
  • 7
  • When you created your Azure Analysis Services, what email did you assign as administrator? Did you create any roles in the model in SSDT to grant any email addresses access? When you deployed the model did it succeed an show you that it processed successfully? – GregGalloway Jan 25 '17 at 02:05
  • What email did you log into Power BI with? One that is an Azure AS admin or a member of a role in the model? – GregGalloway Jan 25 '17 at 02:06
  • thank you for suggestions. when i created azure AS instance i used azure AD account (because assigning other users (i.e. MS id's) not allowed). i didnt create any roles (because i cannot add any users except local). when i deploy model, process succeded. while connecting from powerBI desktop, it don't ask any credentials. – Dmitry Ponkratenko Jan 25 '17 at 09:14
  • Please follow the instructions of this answer: http://stackoverflow.com/a/41783578/5070440 – GregGalloway Jan 25 '17 at 11:25
  • Thank You, this way works fine. But Josh Caplan somehow (as is seen from his post) connects in "Connect Live" mode. is there any way to do the same without linking Azure AD - on-prem AD? – Dmitry Ponkratenko Jan 25 '17 at 15:30
  • yes. You can connect live. Just make sure that you choose organizational account for the auth the first time you connect. No gateway required. No directory sync from on prem is required though it would be recommended. Azure AD auth is all that's required. Are you having issues with this? Can you describe further? – GregGalloway Jan 25 '17 at 15:32
  • unfortunately with "Live" still no luck. there is no models on server PowerBI said. – Dmitry Ponkratenko Jan 26 '17 at 07:48
  • what if you try the latest SSMS? Can you see the models? Can you open an MDX query window? – GregGalloway Jan 26 '17 at 12:19
  • so you followed the instructions to clear permissions and reconnect with Organizational Account permissions? And you have the latest Power BI Desktop? – GregGalloway Jan 26 '17 at 12:21
  • With latest SSMS things a litle bit strange. It connects without any errors (or only show this) **regardless** of password I type. I can open mdx/dmx query window but there is no any bases/project/models in solution explorer too. Browsing service properties to General tab shows what I dont have enough permissions. Clearing and switching to org account in latest PowerBI allows me to import tables from my model, but "Live" mode continues show same warning about models absense. Seems it may be my local machine trouble, so I will try from another environment. Thank You for participation. – Dmitry Ponkratenko Jan 26 '17 at 14:21
  • Fresh machine works great, so, I think somewhere cached my MS ID, under such I connect to azure first time, and wich I unable to set as admin or add to role in my project. – Dmitry Ponkratenko Jan 26 '17 at 15:00
  • You may want to clear the login cache as described here then try again: https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-manage#troubleshooting-connection-problems – GregGalloway Jan 26 '17 at 15:11
  • Thank You Greg! Deleting the AADCacheOM folder fixes both SSMS and PowerBI live mode. – Dmitry Ponkratenko Jan 27 '17 at 08:02
  • great! I posted that as the answer and hope you will mark it as the answer to help others in the future – GregGalloway Jan 27 '17 at 11:26

1 Answers1

0

If SSMS is stuck logging in with the wrong user account you may want to clear the login cache then try again.

Community
  • 1
  • 1
GregGalloway
  • 11,355
  • 3
  • 16
  • 47