Forum Discussion
Gateway Setup - Netezza and SharePoint List
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.
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 😞
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/
