cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sandroalves
New Member

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 workspance schedule.

 

When I create a data source (SQL Server) using the server as IP it appears for the user to configure in the workspance schedule.

 

When I create the connection using server name the connection status shows as successful.

 

I add the user in the datasource.

 

I'm using windows integrated authentication, the gateway server is on the same network/database domain.

 

I looked at the documentation and it should work.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources

 

What could be going wrong?

 

Thanks.

1 ACCEPTED SOLUTION

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-t... 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.

View solution in original post

3 REPLIES 3
Eyelyn9
Community Support
Community Support

Hi @sandroalves ,

 

It seems that your issue has been resolved?

If so, please kindly Accept your post as the solution to make the thread closed. More people will benefit from it.

 

Best Regards,
Eyelyn Qin

GilbertQ
Super User
Super User

Hi @sandroalves 

 

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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-t... 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.

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!