Forum Discussion

Ferdawes's avatar
Ferdawes
Frequent Visitor
9 years ago
Solved

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

 

 

4 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft 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-msft's avatar
    v-yulgu-msft
    Microsoft 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