Forum Discussion
Power BI - SSAS Tabular Connection Issue
Hi, I'm after a little help. I have a Power BI report connected LIVE (not imported) to an instance of SSAS Tabular 2016 which sits on a server in Domain A. However, we are currently migrati...
- Hi there
What it will do is to pass the Custom Data through to the underlying SSAS Tabular instance. Which in your instance it appears due to the current configuration it is passing credentials which it can then validate on the SSAS Tabular Instance.
Hi there
What you would need to do is to go into the Manage Gateways, then click on the SSAS Source.
Then click on Users, then click Map Users
Then you would need to map your users who are looking in to your cube with the expected domain, which should hopefully work as an interim measure.
What you would need to do is to go into the Manage Gateways, then click on the SSAS Source.
Then click on Users, then click Map Users
Then you would need to map your users who are looking in to your cube with the expected domain, which should hopefully work as an interim measure.
Thanks GilbertQ
Hmmm.... OK, so I just re-mapped usernames again - but unfortunately it had no effect - e.g. returned the same error message.
However, I just thought I'd see what happens if I change the user mapping type to 'Custom Data' (and remvoed the user mapping converion from Domain B >Domain A) - and 5 minutes later it appears to now be working for me - though I haven't yet tested for other staff.
What does the 'custom data' feature do in the user mapping pane?
Thanks,
pbix
- Hi there
What it will do is to pass the Custom Data through to the underlying SSAS Tabular instance. Which in your instance it appears due to the current configuration it is passing credentials which it can then validate on the SSAS Tabular Instance.Thanks GilbertQ.
I wish Poewr BI was a little bit more transparent about how it handles certain elements about itself but as it now works with 'custom data' enabled then I'm happy eough!
Thanks again :)