There is no gateway to access the data source XXXXX. Please help...

[alanc]

I've researched this topic till my eyes spin, I do have a valid Gateway (std on-prem) installed and the data source is correct, it shows as 'online'. I have a report that has one file as Direct Query (others are import) and works fine within the PBi desktop. When I publish it gives me this error below. If my gateway connection shows as satisfed then what am I missing? It is a SQL server connection using SQL credentials... again no issue when using desktop. The Connection string (MY-VM\MYSQLSERVER,50560) is the same in the report DSN and in Gateway connection. Runing network port tests under diagnostics on the OPDG shows no errors.

Data source unreachable

There is no gateway to access the data source XXXX. Verify the gateway connection configuration on the dataset settings page and make sure all required data sources are added to the selected data gateway.

[alanc · Accepted solution]

** UPDATE ** So doing some more digging, I created a new Report and just added the direct query SQL table, I published and it worked!  NO data source errors. Then I added to same report an XLS sheet import mode. Now I have two simple table visuals, another publish and now I get "There is no available Gateway".  Based on my research you can have mixed mode with both Import and DQ data sources (some call in composite mode). Looking at this blog it appeared at some time in the past the two could notmix.   https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models?source=recommend....   I found these settings in this topic  https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode then enables you to change your DQ tables to 'Dual', I did that and now the visuals that references DQ table is working as expected. However... I still get this error when publishing although the reports works... very confusing MS!

[Anonymous · Accepted solution]

Hi @alanc ,

First, The gateway being online only means that the service is working, it doesn't mean that the connection is configured correctly, and I'm guessing that you didn't configure all of the data sources to connect the first time around, and only configured only the direct query mode connection. For the later new problem, based on my research, it seems to be a gateway configuration problem as well, you can refer to it:Solved: Your file was published but disconnected - Help - Microsoft Fabric Community

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[alanc · Accepted solution]

** UPDATE ** So doing some more digging, I created a new Report and just added the direct query SQL table, I published and it worked!  NO data source errors. Then I added to same report an XLS sheet import mode. Now I have two simple table visuals, another publish and now I get "There is no available Gateway".  Based on my research you can have mixed mode with both Import and DQ data sources (some call in composite mode). Looking at this blog it appeared at some time in the past the two could notmix.   https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models?source=recommend....   I found these settings in this topic  https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode then enables you to change your DQ tables to 'Dual', I did that and now the visuals that references DQ table is working as expected. However... I still get this error when publishing although the reports works... very confusing MS!