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.
Hi,
I am facing an error with the dataset refresh on PBI Service. We are able to refresh the data in pbi desktop but once published, it is failing with the error "FailedToParseUsername: Error parsing username '<pi>••••••••••••</pi>'.; ErrorShortName: FailedToParseUsername".
I have tried with multiple usernames and process IDs but the result is same.
The dataset has two connections(SSAS tabular and Impala).
Can anyone please help me resolve this.
Thanks in advance.
Is that problem resolved now?
I am facing the same issues in powerautomate while connecting to Webservice using on-prem data gateway
any solutions?
I had the port wrong. Resolved it by correcting. Thank you all for your responses.
Hi @Anonymous ,
Are the gateways and credentials of the two data sources configured correctly?
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Are there any reserved characters in the Username?
No, the username is "ps108633". No reserved characters.
Hi there
have you made sure that when setting up the data source that the credentials used has got Admin access to the SSAS Tabular Database?
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-ssas
Hello @GilbertQ
Thank you for your response.
I am sure the SSAS connection is working. Because I am using the same SSAS gateway in different datasets and they all are running fine. I believe the problem is with Impala connection. The gateway error is only showing "FailedToParseUsername: Error parsing username '<pi>••••••••••••</pi>'.;.
I tried with the same user that is able to refresh the data through PBI desktop but it still doesn't work.
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.