Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 the suggestion was to map the PBI user to local Active Directory. We created a VM to test this but having AD and SQL server together on the same VM does not seem to be supported.
Would anyone be able to assist with how this configuration was set up to enable access to PBI reports?
Hi @Anonymous ,
Is this problem solved?
If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If not, please let me know.
Best Regards
Icey
Hi @Anonymous ,
To get the SSAS live connection working in our Azure VM environment, the setup need to meet the following requirements:
You can refer to these articles:
Setup an Azure Dev VM for Testing Power BI + SQL Server 2016 Integration
Manage your data source - Analysis Services
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.