Microsoft SQL: A connection was successfully established with the server, but then an error occurred
Estimados usuarios, he recurrido al foro porque creo que estoy en un problema que para mi es bastante grande, el dia de hoy intente ingresar a mi sql server management studio v18.4 una nueva base de datos, a la cual queria importar un archivo excel, al darme un error, instale un Microsoft Access Database Engine 2016 Redistributable, logre subir el excel pero al momento de actualizar el reporte y de esta manera tambien descargar el excel desde el Powerbi (como tablas) tengo el siguiente problema: Microsoft SQL: 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.) No tengo problemas para conectarme desde Sql server management studio, pero sí desde powerbi al momento de actualizar. Creo que al instalar el Microsoft Access Database Engine 2016 Redistributable, me elimino el certificado.. o algo así, no soy expero pero necesito us ayuda porfavor!Más allá de CDC: Change Event Streaming en SQL Server 2025
SQL Server 2025 introduce Change Event Streaming, una evolución del CDC que permite capturar cambios en tiempo real con menor latencia y mayor eficiencia. Esta nueva capacidad habilita integraciones modernas con Azure, Kafka y arquitecturas orientadas a eventos, facilitando analítica e IA en streaming.Enterprise Ready Databases - SQL Server 2025
Topic: "Enterprise Ready Databases - SQL Server 2025" Date: December 18, 2025 Time: 9:00AM – 10:00AM PT Speakers: Raj Pochiraju (Principal PM, Azure Data / SQL) Davide Mauri (Principal PM, Azure Data / SQL) Description: Discover how SQL Server 2025 delivers enterprise-ready performance with built-in AI capabilities, advanced security, and developer-focused enhancements to simplify and accelerate modern data solutions.SQL in Fabric
Topic: SQL in Fabric Date: January 8th Time: 9:00AM – 10:00AM PT Speakers: Idris Motiwalla - SQL Database in Fabric: AI, Translytical, Zero ETL, and Reverse ETL Aja Jagnnathan - Integrated Data Real Estate: SQL + Fabric Integration Description: Hear the latest updates directly from the SQL engineering team, with two expert‑led sessions spotlighting new capabilities and practical guidance for SQL + Fabric users. During this session we will cover: SQL Database in Fabric: AI, Translytical, Zero ETL, and Reverse ETL Integrated Data Real Estate: SQL + Fabric Integration
Desktop refresh outperforms Report Server refresh
A little background on the issue that i am attempting to gather info for. My company is running out the On-prem report server, which is awesome, i am a huge fan of Power BI and have been pushing for it with upper management. Now we are running into an issue with the auto refresh feature on the report server. 95% of the time our refresh times out and fails on the server, however, runs fine on the desktop version. Has anyone had this issue before? most of our queries are SQL based and you use that to pull the data we need for our reports. Should we start using DAX language to query the server over SQL? Looking for insight from outside sources, and anything will help on these performance issues
Export data from Power BI server to SQL server
Hello, I need som help figuring out how to accomplish the following. I have a client that is running Power BI report server on premise who needs to export a large number of rows(200 000+) from a Power BI report connected to an Analysis Services cube. For Power BI Desktop and services this is possible using the methods described in the following article: https://biinsight.com/exporting-power-bi-data-to-sql-server/ But these solutions won´t work for Power BI report server. The functionality that I want to achieve for the end user is: End user decides what slicers to use in the report and selects "Export"(Button/Textbox/hyperlink/something else). I can capture the slicer selection as a measure using DAX but then I don´t know how to proceed from there? So far I have two ways that might be possible with some magic :) Insert distinct measure into a table in SQL server(How?) and use SSIS to query Analysis Services cube and export. Pass distinct measure to SSRS report as parameter inside hyperlink(How?) and have the SSRS report run a procedure inserting the distinct measure into a SQL server table and then run SSIS to export. I have searched for a solution but have not been able to find anything that fits what I need. Any help on how to accomplish this would be greatly appreciated! Thanks!
Direct Query report is breaking in Report Server October Version
Hi There.... We have built Power BI Report by connecting to SQL Server with Direct Query mode. When we published to Report Server, the report broke and it is not working. We tried to change the datasources settings, but it is greyed out and not allowing us to do anything. P.S: We know that Power BI supports Direct Query by connecting to SQL Server with October Report server version. Please let us know if there is an bug with current release. Request your assistance. Thanks, Santosh
