Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to build Power BI reports on top of a SSAS tabular model hosted in AWS RDS and publish these to the service using Pro licenses. I am unable to see the data in the service - I dont think I can assign the required server admin role to my windows auth which is needed to allow access via the gateway, I am seeing this error -
"The on-premises data gateway's service account failed to impersonate the user"
Has anyone had success using SSAS on RDS for enterprise hosting of semantic model for Power BI?
Hi, @LeadAnalyst
Can you share the screenshot of Underlying error message?
Here are some similar solved posts, you can reference:
Solved: The on-premises data gateway's service account fai... - Microsoft Power BI Community
Solved: Cannot add new data source to gateway - Microsoft Power BI Community
Solved: Error: the on-premises data gateway's service acco... - Microsoft Power BI Community
You can try their approach, if it doesn't work, please feel free to ask me.
Best Regards,
Community Support Team _Janey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.