Forum Discussion
Gateway connected but can not access SSAS tabular, The name provided is not a properly formed accoun
I host SSAS on Azure VM, connect SQL server as Data source in same VM. install and develop report with Power BI desktop in same machine.
I install the Power BI on promised gateway in order to publish to my account. After setup the gateway setting in PowerBI, all thing looks well (report green connected message), but when click datasets, it shows an error said: ''there was a data source access error. Please contact the gateway administrator".
Then I try directly use "Get Data" to connect to SSAS, it shows error following:
How can I debug this problem?
I search a lot and think it might need to setup "Map user names".
I don't understand this function because the two options 'Effective User name'/'CustomData' are so comfusing and I don't know what should to be `Replace`d?
when I try setup the 'CustomData' with anything, there will show another Error:
The following system error occurred: There are currently no logon servers available to service the logon request
I have already spend 8 hours on this problem, and now I think I have already try all the way I can, is any one can help me with the problem? or tell me know to trace with above message.
P.S. Currently in my local machine, I use windows main account to login to SSAS, it looks like 'TEST\abc', and the local SQL server using the same account to login too (also setup SQL account login).
6 Replies
Hi jchbh,
Do you use an account of your Azure VM or an account of local VM to login SSAS?
In your scenario, you would need to join your SSAS Azure VM in a domain, and sync your local AD to Azure AD, otherwise, you will get the above error when connecting to SSAS from Power BI Service.
There is a similar thread for your reference.
https://community.powerbi.com/t5/Integrations-with-Files-and/Connecting-to-SSAS-tabular-model/td-p/79355Thanks,
Lydia ZhangSimilar situation. This has to be the simplest configuration possible:
- I have a standalone PC (i.e. not on a corporate network, not in a Windows network or domain) with a lot of horsepower on a fast network
- I have a perfectly functional SQL Server instance for database and Analysis Services Multidimensional
- I have installed the Power BI Gateway, and everything reporting "Online: You are good to go." for the two on-prem databases - the gateway sees them
- If I try to "Get Data" from inside the BI Service, the SSAS data source is listed - the service sees it on the gateway
- But if I try to click on that Data Source Name, here's the infamous, "Something went wrong ... The name provided is not a properly formed account name." error message
- BI Desktop has no problem seeing and building with these data sources
- If I publish from Desktop ("Publishing succeeded") and try to open the result in Service, I get "Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again."
If I read the currently inadequate information on the web for this situation, it sounds like this all boils down to Active Directory.
Seriously? A standalone machine can't push data to the service without being a part of Active Directory? Please, somebody with some credibility tell me that's not the case, and document a REAL solution.
- zoloturu
Memorable Member
jchbh, I can tell how I've mapped.
I have local PC and PBI service accounts.
You can select 'Effective user names'. You should see your PBI service account in list of users in tab 'Users' below.
Then you put this account name like [email protected] to 'Replace' field and your local PC like [email protected] to 'With' field.
Then If you enter your PBI service account one more time into field 'Original name' you can press 'Test rule' to check if it is correct.
Then press 'Ok'
mapping
