Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Unable to access reports on PBI Service

We are working on configuring power bi gateway for accessing SSAS tabular live datasource via PBI Service, but having issues with authentication. We followed a vblog on how to work around this and th...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
6 years ago
Hi there

In order for this to work you need to have an account on your On-Premise AD that will be assigned to the Security Role in your SSAS Tabular Server (This allows that user to have FULL admin access)

Then when configuring the Gateway, you use this same AD Account when creating the data source.
shilpavish's avatar
shilpavish
Frequent Visitor
6 years ago

Hi GilbertQ  Thanks for your response. But as I mentioned in my original post, we are running into issues while trying to install AD on a VM that has SQL server on-prem. Do you know if this is even feasible since Microfoft recommends against having AD and SQL server on same VM

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    6 years ago
    Hi there

    I would honestly listen to the best practice advice and install them on separate VM's

    I have found you can save a lot of time and potential issues trying to do it in another way.
    • shilpavish's avatar
      shilpavish
      Frequent Visitor
      6 years ago

      Hi GilbertQ  Thanks! you mentioned "I would honestly listen to the best practice advice and install them on separate VM's"

      Is there any documentation that you recommend on install them opn separate VMs?

      What components go on what VM and how would they relate to each othet? Any insights would help!

       

      Thanks

      Shilpa