Forum Discussion
Error al actualizar datos en PowerBI Service con AtlasSQL
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?
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.
4 Replies
- lbendlin
Super User
Did you create that connection on your gateway?
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:
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.
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.
