Forum Discussion

Jonathan_P's avatar
Jonathan_P
Icon for Helper II rankHelper II
9 years ago
Solved

Data source information need to match or not?

Hello,

 

I am wondering why now suddenly the data source information does not need to match anymore between Power BI Desktop and the Power BI Service data source on the data gateway. Before it was mandantory. Am I doing something wrong? I double checked and the server name and database name I see on the 'Data source settings' in Power Bi Desktop is clearly not what I see on the gateway data sources. Of course, I ensured that the report was published by overwriting it.

 

There is information about it here: Troubleshooting the On-Premises Data Gateway.

 

What I read there is:

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.

 

This is not a problem of course but I am just curious. Have you experienced it as well? Is it new?

 

Thanks

General Comment
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Jonathan_P,

     

    I agree with Anonymous that the gateway data source server name and database name need to be the same as in desktop.

     

    In your scenario, please go to the Dataset settings, you can find which data gateway is used by the dataset.

     

     

    Then please go to Manage Gateways, find this gateway, go through all data sources under this gateway, check if any data source use the same connection information as in desktop.

     

    Also please keep the data gateway up-to-date.

     

    Best Regards,
    Qiuyun Yu

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Jonathan_P The requirement should still be in affect. Do you have multiple gateways? Is the dataset that you are publishing actually refreshable and using that gateway?

     

    • Jonathan_P's avatar
      Jonathan_P
      Icon for Helper II rankHelper II
      9 years ago

      Anonymous, yes, we defined multiple gateways. However, on the dataset settings under "Gateway connection", I selected the gateway containing the data sources informations that is not matching those on the report/dataset (the ones I entered with Power BI Desktop). Then to test I have changed some data (on the source database) and force a dataset refresh manually. The new data was pulled into the dataset successfully.

    • Jonathan_P's avatar
      Jonathan_P
      Icon for Helper II rankHelper II
      9 years ago

      I just tested using another organization (this time on our own Office 365 used for dev) and there is no problem. If the server or database name does not match, I can't even select the gateway on the dataset settings. So then I don't know why on one organization I have the problem but not on the other. Well, that's not the same report. And on one case, the report needs 2 data sources, on the other only one. If I have other information about my tests, I will follow-up on that thread but right now that's weird.

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Icon for Community Support rankCommunity Support
        9 years ago

        Hi Jonathan_P,

         

        I agree with Anonymous that the gateway data source server name and database name need to be the same as in desktop.

         

        In your scenario, please go to the Dataset settings, you can find which data gateway is used by the dataset.

         

         

        Then please go to Manage Gateways, find this gateway, go through all data sources under this gateway, check if any data source use the same connection information as in desktop.

         

        Also please keep the data gateway up-to-date.

         

        Best Regards,
        Qiuyun Yu