User Profile
ManuelEscanez
Helper I
Joined 3 years ago
User Widgets
Contributions
Re: Help: Report Server Scheduled refresh not working
Make sure you have your ODBC driver configured as System DSN. User DSN is valid when using Powerbi Desktop, but when you publish on the server you ALSO need to have the same ODBC source configured, otherwise the server has no possiblity to connect. Good luck745Views0likes0CommentsRe: Issues regarding power bi report server
Hi, The environment variable PBI_SQL_TRUSTED_SERVERS shall be in the PbiRS machine and you have to write the server name where you have the SQLServer Engine running. Perform a "Powerbi Report Server" service restart and should work fine.... Rebooting the PbiRS machine won´t do any harm as well....... Good luck13KViews0likes5CommentsRe: Issues regarding power bi report server
Good afternoon, I already unistalled the May2024 version and rolled back to Jan24. I had to restore the DDBB, unistall pbirs and install again to recover the Directquery reports that were critical to some users…. Meanwhile, if I want to install again the may24 (and I imagine the coming versions), can you confirm to me the workaround in the environment variable?? I understood that the variable should be: Variable Name: PBI_SQL_TRUSTED_SERVERS Value: ¿¿BBDD Server Name?? Do I create this variable under “User Variable” or “System Variable”??? Thanks8.5KViews0likes0CommentsRe: Price question: Report server or Power BI PPU licenses
Good afternoon, From my experience skip PBIRS if you have mobile users. Performance even in 5G networks is awful. Better keep using the cloud service even if is more expensive..... Anyway, if you want to test youself, you can use a trial license of PBIRS for 1 month and test it...1.5KViews0likes0CommentsRe: Issues regarding power bi report server
Going deeper on the problem, it looks that the SERVER SIDE of PBRS is trying to stablish an encrypted connection with the SQLServer which is not configured to work like this. The Directquery reports work fine in PbiDesktop but, when uploaded on the server they won´t load. This issue has been created 100% by the May 2024 update of the PBIRS. It was working fine til last night when I updated the server....8.1KViews0likes0CommentsRe: Issues regarding power bi report server
Good morning, I am having the same issue with directQuery models. Some of them are showing that "we could not conect to Analisys Services" Those reports with a landing page show more detail about the error: "A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - La cadena de certificación fue emitida por una entidad en la que no se confía.);La cadena de certificación fue emitida por una entidad en la que no se confía. La interfaz de IDbConnection ha producidola excepción." Any idea how to solve the issue????8.5KViews0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.