Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Creating data source

Hello,   I'm doing some tests with the PBI gateway.   I noticed that when I create a data source (SQL Server) using the server with the (FQDN) it does not appear for the user to configure in the ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi,

     

    using the FQDN is working as the connection is established. Shows successfully when we save, so it's working.

     

    What happens is that this connection does not appear to the user in the gateway's data source list.

     

    I was reading the documentation FAQ they mention that this happens when the datasource connection setup in PowerBI Desktop is not using the same server as the gateway datasource datasource.

     

    I will test this today to confirm.

     

    https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot#unable-to-see-the-data-gateway-data-sources-in-the- get-data-experience-for-analysis-services-from-the-power-bi-service

     

    #####

    Issue: Cannot see data gateway data sources in experiment Get Analysis Services data through Power BI service

    Solution: Make sure your account is listed on the Users tab of the data source in the gateway configuration. If you do not have access to the gateway, check with the gateway administrator and request verification. Only accounts in the Users list can see the data source listed in the Analysis Services list.
    #####

     

    Thanks.

GilbertQ's avatar
GilbertQ
Super User
4 years ago

Hi Anonymous 

 

If the FQDN is not working it would potentially be an issue that your Gateway server cannot resolve the FQDN to the IP Address.

 

If you can test the FQDN when you are logged into the Gateway Server?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi,

     

    using the FQDN is working as the connection is established. Shows successfully when we save, so it's working.

     

    What happens is that this connection does not appear to the user in the gateway's data source list.

     

    I was reading the documentation FAQ they mention that this happens when the datasource connection setup in PowerBI Desktop is not using the same server as the gateway datasource datasource.

     

    I will test this today to confirm.

     

    https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot#unable-to-see-the-data-gateway-data-sources-in-the- get-data-experience-for-analysis-services-from-the-power-bi-service

     

    #####

    Issue: Cannot see data gateway data sources in experiment Get Analysis Services data through Power BI service

    Solution: Make sure your account is listed on the Users tab of the data source in the gateway configuration. If you do not have access to the gateway, check with the gateway administrator and request verification. Only accounts in the Users list can see the data source listed in the Analysis Services list.
    #####

     

    Thanks.