Forum Discussion

FedeBrusa's avatar
FedeBrusa
New Member
1 year ago
Solved

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 ...
Need Help
  • FedeBrusa's avatar
    FedeBrusa
    1 year ago

    quiero agradecerles a AmiraBedh y a Anonymous por la atencion brindada a mi consulta, pero finalmente no era un problema del power bi, sino de permisos de acceso a la base de datos. ya he podido resolver el tema y armar las consultas deseadas. muchas gracias. 

AmiraBedh's avatar
AmiraBedh
Super User
1 year ago

 

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.