Gateway Setup - Netezza and SharePoint List

[newpbiuser01]

Hello,

I have a report that's leveraging data from a Sharepoint list and Netezza. We already have a gateway configured for the Netezza source, so typically, I just select the gateway, apply it, and no credentials are required. With the sharepoint list, when I select the gateway for my netezza source, the "Apply" option is still greyed out.

I then try to check the credentials and for the Sharepoint List, I added the credentials and everything seems to be fine. However, adding my credentials to the netezza source does nothing and stay on the following screen:

Would anyone know how to configure the gateway for the netezza source when you have a sharepoint list? I dont have this issue when I have data from Netezza or just from Sharepoint, its when I have both, that I'm unable to set it up and without this, I can't refresh the data in my report. 

I'd really appreciate any help! 

[lbendlin]

Looks like you are merging these sources in Power Query. Try not to do that, instead link them in the data model.  That way you don't need to declare the sharepoint list connection in the gateway.

Another consideration is to skip the connection test for Netezza if you are confident that the credentials are correct.

[newpbiuser01]

Hi @lbendlin,

I am not merging the tables in Power Query, or even linking them in the data model. I just use the measure to get the value I need from the netezza table and then perform a calculation within the measure. Both the tables are completely unrelated.  

I tried refreshing my data without testing the credentials, but I get the error saying one of the data source is missing credentials. When I put my credentials, it wont throw an error or connect, just gets stuck. It won't let me set the gateway, or accept my credentials 😞 

[lbendlin]

You can raise an issue at https://issues.powerbi.com . If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/