Forum Discussion
visualizacion
tengo un ERP con 4 bases de datos donde 1 de ellas es la madre de las demas, es decir, en base a la primera, se armaron las otras.
a partir de power bi, tengo una consulta sql armada por el propio erp , que utiliza una funcion disponible dentro de la estructura de la base de datos.
ahora bien, en 2 de estas 4 empresas, la consulta se ejecuta sin problemas y en otras dias, me arroja un error que no se puede ejecutar una funcion. tienen idea de que puede estar pasando?
mismas estructuras de bases , misma consulta, resultados distintos.
aguardo sus comentarios, muchas gracias.
7 Replies
muchas gracias, pero no consigo resolverlo.
Can you share more information about your issue ? screenshots maybe ?
Hi FedeBrusa,
Thanks for reaching out to the Microsoft fabric community forum.
Just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
I would also take a moment to thank AmiraBedh, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support TeamIf this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.
Hi FedeBrusa,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.Hi FedeBrusa,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.
Thank you.
I think that your issue can be related tothe wrong permissions set for executing the function so you need to check if the user running the query has EXECUTE permissions on the function.
Even though the databases have the same structure, the function may not be present in all of them or may be defined differently. Try running in all databases to confirm its existence.
SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME = 'YourFunctionName'Also, try to check :
- If the function relies on collation-sensitive operations (like comparing strings), differences in collation settings between databases could cause failures.
- If the function references objects in another database or uses a linked server, verify that these dependencies exist and are accessible in all databases.
