Forum Discussion
On promise data gateway problem
I am successfully connected to the promise data gateway but the report publication is missing data source and shows this message
HI v-yulgu-msft
Thanks for taking time to help on this. i resolved this problem the solution is : i configured mapping rule for SSSAS.
For Analysis Services data sources, you can configure custom User Principal Name (UPN) rules. This will help you if your Power BI service login names do not match your local directory UPN. For example, if you sign into Power BI with [email protected], but your local directory UPN is [email protected], you can configure a mapping rule to have [email protected] passed to Analysis Services.
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-ssas/
4 Replies
- v-yulgu-msftMicrosoft Employee
Hi Ferdawes,
This is usually caused by one of the following:
- The data source information does not match what is in the underlying dataset. The server and database name need to match between the data source defined for the on-premises data gateway and what you supply within Power BI Desktop. If you use an IP Address in Power BI Desktop, the data source, for the on-premises data gateway, needs to use an IP Address as well.
- There is not a data source available on any gateway within your organization.
In short, please check whether you have add relative data source to on-premises gateway in Power BI Service.
If you have configured that, then, you should make sure the server and database name you defined here are the same as that in Power BI desktop. (File->Options and settings->Data source settings)
Best regards,
Yuliana Gu - v-yulgu-msftMicrosoft Employee
Hi Ferdawes,
Have you resolved your problem? If so, would you please mark the helpful reply as an answer or sharing your solution so that it can benefit more users?
Regards,
Yuliana Gu- FerdawesFrequent Visitor
HI v-yulgu-msft
Thanks for taking time to help on this. i resolved this problem the solution is : i configured mapping rule for SSSAS.
For Analysis Services data sources, you can configure custom User Principal Name (UPN) rules. This will help you if your Power BI service login names do not match your local directory UPN. For example, if you sign into Power BI with [email protected], but your local directory UPN is [email protected], you can configure a mapping rule to have [email protected] passed to Analysis Services.
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-ssas/
- v-yulgu-msftMicrosoft Employee
Hi Ferdawes,
Glad to hear that you have resolved it. Thanks for your sharing. Would you please kindly mark your solution as an answer so that other users having similar problem can find the solution more easily?
Thanks,
Yuliana Gu