Forum Discussion
Gateway Connections
What does this 'red x' mean next to my Dynamics URL? It seems to indicate a credentials failure, but the refresh works and it pulls updated info into Power Query just fine. I am not sure what this is supposed to mean or how to fix it.
Hi burtta - the red x should be okay. It indicates that the Connection will not require the Gateway to run because the Power BI can connect directly to the Web data. There might be caveat though. If you need to combine Gateway and Non-Gateway data in Power Query, you may need to create a connection within the Gateway to replace the Web credentials. This allows Power Query to combine the different data sources using the Data Gateway. This won't be necessary if the two data sources are loaded independently to the data model and then combined or related in the data model.
1 Reply
Hi burtta - the red x should be okay. It indicates that the Connection will not require the Gateway to run because the Power BI can connect directly to the Web data. There might be caveat though. If you need to combine Gateway and Non-Gateway data in Power Query, you may need to create a connection within the Gateway to replace the Web credentials. This allows Power Query to combine the different data sources using the Data Gateway. This won't be necessary if the two data sources are loaded independently to the data model and then combined or related in the data model.