Error al actualizar datos en PowerBI Service con AtlasSQL

[Kimat]

He hecho un tablero en PowerBI Desktop conectandome a un origen de datos por medio de AtlasSQL a una base de datos creada en MongoAtlas, en PowerBI Desktop el origen de datos funciona perfectamente, y puedo actualizar el origen de datos pulsando el botón de Actualizar. 
Al publicar el tablero a PowerBI Service, no puedo actualizar mis datos y obtengo el siguiente error:

¿PowerBI Service no es compatible con el origen de datos mediante Atlas SQL?

[Anonymous · Accepted solution]

Hi @Kimat ,

Thanks @lbendlin  for the quick reply. I have a few additions to this:

If your MongoAtlas database is hosted in such a way that Power BI Service cannot directly access it (for example, behind a firewall), you will need to configure and use a local data gateway. The gateway acts as a bridge between Power BI Service and your data source. Make sure that the gateway is online and correctly configured. You can find more information on configuring the local data gateway here:  Install an on-premises data gateway | Microsoft Learn

After publishing your dashboard, go to the dataset settings in Power BI Service and make sure that the credentials and connection settings are correctly set up for AtlasSQL. This includes verifying that the authentication and connection details are correct. Add or remove a gateway data source - Power BI | Microsoft Learn

Best Regards,

Neeko Tang

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

[Anonymous]

Hi @Kimat ,

Whether the advice given by @lbendlin  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Best Regards,

Neeko Tang

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

[lbendlin]

Did you create that connection on your gateway?

[Kimat]

I don't really know where to create that connection, is that in the PowerBi Service?
In my semantic model i only got the following options: