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!
Onpremise direct query surprise
I'm tryng to make the onpremise direct query work for mySQL / maria DB. I have successfully set up a deployed SQL server direct query report to reporting server. It just works fine and I could see the connection string if i click on the manage tab in reporting server. As you can see below, the data source is enabled and visible at the righ pane. All looks good for SQL server. Now coming to Maria DB /SQL server. To my surprise, the direct query using maria DB works just fine in desktop, but it doesnt work on pn-premise server. After teh deployment, if I come to manage tab, the data source tab is grayed out.. Why PBI behaves differently for mariadb whereas it just works fine for SQL server? Maria DB screen print below.
SSAS Tabular Model Process - Low Memory Error (Standard Edition)
This is the environment I work with: Microsoft SQL Server 2017 Standard Edition (64-bit) One database engine instance with 3 databases One Analysis Services instance with 4 databases (Tabular model, average size of each database 3.9 gb) Database engine and ssas are on same server. Server has 256gb ram; 80gb allocated to database engine, 60 gb allocated to etl tool. I read, if SQL Server is Standard Edition, it will assign a limited memory (15gb) to analysis service database. Also I can not create a new partition for one table. I wanted to create multiple partitions for one table and refresh/process only partition which has hot data. But I couldn't do that. So unfortunately, I have to full process for each tables. If there is an option to achieve this? Here are my steps to process: When I try to deploy ssas tabular model via Visual Studio, it throws "low memory" error. I have 10 tables in my tabular model, so I filtered table queries to "select top 10". After that I deployed the model successfully. After first step, I edited and removed "top 10" part from each tables partition in SQL Server Management Studio. I extracted full process script for each partitions, created a linked server between database and ssas instance. I created cursor to process partition of 10 tables. But I got an error "low memory". Here is an example of process a partition. DECLARE @MyScript NVARCHAR(MAX) = '{"refresh":{"type":"full","objects":[{"database":"Dwh_Reports","table":"Fact Sales","partition":"Par_Fact_Sales"}]}}' EXEC (@MyScript) AT SSAS To sum up, my questions; I have 4 databases on my ssas instance. That means, per instance uses 15gb memory and i have to allocate 60gb memory to ssas? My ssas instance configuration is default, I didn't change anything; Memory \ LowMemoryLimit -> Value : 60 Memory \ TotalMemoryLimit -> Value : 80 Memory \ VertiPaqMemoryLimit -> Value : 60 Memory \ VertiPaqPagingPolicy -> Value : 1 Do I have to change this configurations?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!
Pulling large data from SQL server and filters
Hi, I am trying to automate a process. The initial data is coming from sql server. This data is over 500k rows so the initial load is even slow. My business partner will evenually use each account for a balance sheet in a separate report (many accounts and reports). What is the best way to set this up and how should I then create a filter or report on the account while still managing the performance. I need flexibility to create formulas and use dax so I used an import query in sql server.
Use Multiple data sources on same server
Hello, I am somewhat new to PowerBI. I am trying to use multiple data sources located on the same server. There are two separate databases with different credentials. I am using import mode to connect. So lets say I have DB1 and DB2 is on server P and each has a user DB1_user and DB2_user. Once i connect to DB1 with userid DB1, when i try to create a query for DB2 then the query which i created for DB1 says invalid credentials. It gets updated to the credentials of DB2 database. I am not sure how to have two data sources with separate crentials in one report. Is this possible? I am using PowerBI report server version March 2018.
