database

16 Topics

SQL Engine Improvements
Únete a este webinar para conocer las últimas novedades directamente del equipo de ingeniería de SQL, con dos sesiones dirigidas por expertos centradas en el procesamiento de consultas del motor SQL y en las mejoras recientes de rendimiento y fiabilidad para la comunidad de datos de Azure. Topic: "SQL Engine Improvements" Date: January 22, 2026 Time: 9:00AM – 10:00AM PT Speakers: Derek Wilson - SQL Engine – Query Processing Dimitri Furman - SQL Engine Performance and Reliability Improvement 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 Engine – Query Processing SQL Engine Performance and Reliability Improvement Este evento forma parte de la SQL Community Engineering Connection Series que iremos publicando en esta comunidad.
franlens
5 days ago Place Cloud & Data Valencia
78Views
0likes
0Comments
Streaming your database - Easier said than done?
Data Engineers in Toronto September 2026 Semimonthly Meeting Topic: Streaming your database - Easier said than done? Abstract: Do you need to stream your database? So did I! Here’s what to expect. In my journey as a contractor for a major cybersecurity company, I implemented a Change Data Capture (CDC) system that aimed to seamlessly stream client databases into a centralized cloud solution for analytics and enhanced features. However, after deploying the code, I quickly realized that the reality was far more complex than anticipated. Despite using an off-the-shelf product, I encountered unexpected challenges related to scaling, data formats, integrations, and deployment—issues that took me by surprise and required significant adjustments. Over the course of 18 months, my team and I navigated these hurdles to create a robust system designed for scalability and resilience against failures. In this talk, I’ll share key lessons learned and practical tips for developers and architects embarking on similar projects. You'll gain insights into preparing for potential surprises and overcoming challenges in building a reliable CDC system. Speaker: Sigal Shaharabani, Technical Group Leader & Couchbase Ambassador Speaker Profile: Sigal Shaharabani is a Technical Leader and a Group Leader at Tikal and a Couchbase ambassador, with a great passion for backend and data systems. She started her technological career way back in 1996, working for the government, a variety of corporations, and small start-ups. Her favorite programming language is Kotlin, and will love any excuse to talk about it. In her spare time she enjoys swimming and Israeli folk dancing.
michaelolafusi
5 days ago Place Data Engineers In Toronto
63Views
0likes
0Comments
How to increase data retention period in ReportServer database for monitoring dashboards
Hi everyone, I'm currently using the ReportServer database to build a monitoring dashboard for my SSRS reports. Everything is working fine, but I’ve noticed that the available data only covers the last 60 days. For better trend analysis, I need to retain data for a longer period (e.g. 90 days or more). Does anyone know how I can increase the data retention period in the ReportServer database, so that my dashboard can show a broader timeline? Any help would be greatly appreciated! 🙏 Thanks in advance
Solved
mtavana66
1 year ago Place Report Server
1KViews
0likes
2Comments
Error while connecting our SQL SERVER for a particular Database to Power BI
I can easily connect my sql server with other database except with one database. The error is given below : Details: Microsoft.Mashup.Evaluator.Interface.ErrorException: The given key was not present in the dictionary. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: The given key was not present in the dictionary. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: The given key was not present in the dictionary. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: The given key was not present in the dictionary. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: The given key was not present in the dictionary. ---> System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. ---> System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. at System.Collections.Generic.Dictionary`2.get_Item(TKey key) at Microsoft.Mashup.EngineHost.Services.StreamStorage.OpenStream(Int32 id) at Microsoft.Mashup.EngineHost.Services.EncryptedPersistentCache.EncryptedStorage.OpenStream(Int32 id) at Microsoft.Mashup.EngineHost.Services.PersistentObjectCache.TryGetValue(String key, DateTime maxStaleness, CacheVersion minVersion, Func`2 deserializer, Object& value) at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.LoadCachedServerMetadata() at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.get_ServerMetadata() at Microsoft.Mashup.Engine1.Library.Sql.SqlEnvironment.get_EngineEdition() at Microsoft.Mashup.Engine1.Library.Sql.SqlEnvironment.get_IsTrident() at Microsoft.Mashup.Engine1.Library.Sql.SqlEnvironment.TryLookupDatabaseItem(SchemaItem item, SchemaItem& adjustedItem, Value& data) at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.GetNavigationPropertiesRecord(Nullable`1 itemFilter) at Microsoft.Mashup.Engine1.Library.Common.DbCatalogTableValue.GetEnumerator() at Microsoft.Mashup.Engine1.Language.Query.SelectRowsQuery.SelectRowsEnumerable.GetEnumerator() at Microsoft.Mashup.Engine1.Language.Query.SkipTakeEnumerable.GetEnumerator() at Microsoft.Mashup.Engine1.Language.Query.QueryTableValue.GetEnumerator() at Microsoft.Mashup.Engine1.Runtime.TableValue.TryGetValue(Value key, Value& value) at Microsoft.Mashup.Engine1.Runtime.TableValue.get_Item(Value key) at Microsoft.Mashup.Engine1.Runtime.Library.List.ElementWithListCheckFunctionValue.Invoke(Value collection, Value key) at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(Value frame) at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(Value frame) at Microsoft.Mashup.Engine1.Language.FieldAccessInstruction.Execute(Value frame) at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(Value frame) at Microsoft.Mashup.Engine1.Language.RuntimeFunctionValue1.Invoke(Value arg0) at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index) at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index) at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field) at Microsoft.Mashup.Engine1.Language.FieldAccessInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0) at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index) at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index) at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field) at Microsoft.Mashup.Engine1.Language.FieldAccessInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction1.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0) at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index) at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index) at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field) at Microsoft.Mashup.Engine1.Language.FieldAccessInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.Instruction.ExecuteCondition(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.IfInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0) at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index) at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index) at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field) at Microsoft.Mashup.Engine1.Language.FieldAccessInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction1.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction1.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.Instruction.Execute(MembersFrame1& frame, Instruction[] instructions) at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0) at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index) at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index) at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field) at Microsoft.Mashup.Engine1.Language.FieldAccessInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction1.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.Instruction.ExecuteCondition(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.DebugInstruction.ExecuteCondition(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.IfInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame)
KeshavK0310
2 years ago Place Report Server
687Views
0likes
1Comment
Unable to create a database for the report server
Hello, currently I am trying to create a database using the configuration manager, but as soon as I reach the task for running the script (first screenshot) I get the following error: Unfortunately I couldn't find a way to change the language while setting up the reporting server, so the error log is in german. System.Data.SqlClient.SqlException (0x80131904): Ungültige Sortierung 'Latin1_General_100_CI_AS_KS_WS'. bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) bei System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bei Microsoft.ReportingServices.Common.DBUtils.ApplyScript(SqlConnection conn, String script, ICommandWrapperFactory commandWrapper) bei Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script) bei ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script) ClientConnectionId:7f8fbb1c-6012-428d-adbf-1e31e2eb89ec Fehlernummer (Error Number):448,Status (State):3,Klasse (Class):16
Solved
mkel
2 years ago Place Report Server
814Views
0likes
1Comment
Your file was published, but disconnected
Hola, Estoy tomando varios archivos excel, carpetas y otros power BI para crear un reporte. Al ser publicado me aparece lo siguiente: Y cuando entro a "Open dataset settings" me aprece lo siguiente: De igual manera no me deja seleccionar una puerta de enlace: Lo anterior hace que no pueda tener la opción de actualizar automaticamente y algunos visuales que se alimentan de infromación extraida de otro power BI no puedo verlas: ¿Alguien puede ayudarme a solucionar este problema?
AlexRios
3 years ago Place Report Server
4.1KViews
6likes
7Comments
Splitting data out over a predefined percentage and using that data for new calculations
Hi BI Community I'm having difficulties to visualize an important feature in our reports. I used to have the data in a fully different format, in the new environment I'm unable to do SQL queries on my data so I'm bound to Power BI solutions. Part of my issue already begins at my splitted orders table. Splitted orders 1 Order No Owner 1 Owner 2 Percentage ORDER1 Person1 Person2 50 ORDER3 Person3 Person1 75 I manually made Splitted orders 2 out of the data from splitted orders 1 as I wasn't able to have any code do the trick in Power BI itself. Splitted orders 1 is actually a dynamic table that's getting data from our employees, they can add but also modify/delete. Is there a way I can get DAX or Power Query to give me the values as in splitted orders 2 or is there no other option than to rebuild the system to which they enter their data? Or perhaps my issue is't beginning here like I thought it was and I can keep splitted orders 1. Splitted orders 2 Order No Owner Percentage ORDER1 Person1 50 ORDER1 Person2 50 ORDER3 Person3 75 ORDER3 Person1 25 Situation: We have sales orders, they are being split out in a header table and a lines table. Every sales order is property of one owner. Order Header Order No Owner ORDER1 Person1 ORDER2 Person2 ORDER3 Person3 In special cases an order can get 'splitted', meaning that the total amount of the order gets devided over a specific percentage and two owners. (see the issue on the top about splitted orders, here I used the splitted order 2) Splitted orders Order No Owner Percentage ORDER1 Person1 50% ORDER1 Person2 50% ORDER3 Person3 75% ORDER3 Person1 25% I thought that making a full join on the splitted orders and the headers, along with the new headers and the lines would help me fix the issue. Yet this doesn't seem like a best practice to me as this is making the entire report extremely slow. So I continued to look for a different solution. I kept the full joined headers and calculated the lines based on the percentage of the splitted order. But I'm unable to get my sums to work that way. As I cannot calculate the field without making a sum() of all values. Order No Owner Percentage ORDER1 Person1 50% ORDER1 Person2 50% ORDER2 Person2 100% ORDER3 Person3 75% ORDER3 Person1 25% Meaning I made a calculated field AmountSplit = sum([Amount]) * sum('SplitHeader'[Percentage]) This works for me on the order level but obviously I need to keep the correct sums if I start combining my orders. Order No Product Amount ORDER1 Product1 10 ORDER1 Product2 20 ORDER2 Product1 10 ORDER2 Product2 10 ORDER2 Product3 10 ORDER2 Product4 10 ORDER3 Product1 20 ORDER3 Product2 10 ORDER3 Product3 20 If I would want to show the total amounts per person I'd need to get the AmountSplit1 result un-summarized. The DAX code makes sure I'm having AmountSplit2. I'm unable to remove the SUM part as it's no longer calculating after that. Owner Amount AmountSplit1 AmountSplit2 Person 1 30 27,5 60 Person 2 40 55 105 Person 3 50 37,5 37,5 Also tried making a calculated column in my lines both using SUM and no SUM. In the example I summarised the tables with only the basic data that has to be recalculated but there are a bunch of other fields in both header and lines that I need for calculations. Anyone who might have the magical solution? Thanks!
Solved
KatrienVds
4 years ago Place DAX Commands and Tips
6.1KViews
0likes
14Comments
Is there an easy way to split out targets over months based on fixed percentage?
Hi power bi community, I'm searching for an efficiënt way to create my monthly targets in power bi. It seems like such an 'easy' question but I cant wrap my head around it. Probably making it a lot more difficult than it should be. Currently I have everything stored in yearly targets (& types) per salesperson. For the example I narrowed it down to users only. Salesperson target 2019 target 2020 target 2021 Person 1 100.000 200.000 100.000 Person 2 200.000 150.000 100.000 Person 3 100.000 100.000 200.000 Person 4 250.000 200.000 250.000 Now I want to spread it out over 'monthly' targets. There is a 'fixed' percentage of those yearly targets that is needed per user per month. Which I also stored in a table so I can change those easily if the estimated percentages would change over time. Month percent 1 5% 2 10% 3 10% 4 11% Which leads me to having to create somthing like this, I think thats the easiest way to use the data in different graphs to split out my monthly target over monthly sales. YYYY MM Salesperson month target 2019 1 Person 1 5.000 2019 1 Person 2 10.000 2019 2 Person 1 10.000 2019 2 Person 2 20.000 2020 1 Person 1 10.000 2020 1 Person 2 7.500 2021 1 Person 1 5.000 2021 1 Person 2 5.000 Is there a formula or easy way to achieve this? I feel like it shouldn't be this hard to build / calculate this table. The 'target table' and the 'percentage' table are manually entered tables and the 'Date' table is a calculated one in power bi. Which means I can't run an SQL query with cases as an import statement. I don't want to have to manually start working out all the calculations in excel so I can copy paste that into a new table. It would also limit my abilities to change the monthly percentages in the future, making me have to recalculate everything. I've seen something remotely similar but that goes from months to days with a crossjoin but in this case the percentage I need per month is already pre-defined and it shouldn't generally split out over all months. Already tried making the sum per year and show those in a table next to the dates so I could split those out over the percentages per month but then I miss my sales people. Which is also required to watch it on person level not only month level.
Solved
KatrienVds
5 years ago Place DAX Commands and Tips
2.5KViews
0likes
2Comments
PBI Server change database: No such host is known
To create a sandbox environment I want to set up a PBI Server on my local machine. During the setup when I want to setup a database I get the following error message with the 'Credentials' part: No such host is known Stacktrace: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Net.Sockets.SocketException (0x80004005): No such host is known at System.Net.Dns.GetAddrInfo(String name) at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6) at System.Net.Dns.GetHostEntry(String hostNameOrAddress) at ReportServicesConfigUI.RSDatabase.IsLocalDbServer(String dbServer) at ReportServicesConfigUI.RSCredentialPanel.EnsureHaveValidData() at ReportServicesConfigUI.RSCredentialPanel.NotifyNextClicked() at ReportServicesConfigUI.DatabaseWizard.MovePage(MoveDirection direction) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) ************** Loaded Assemblies ************** mscorlib Assembly Version: 4.0.0.0 Win32 Version: 4.8.4180.0 built by: NET48REL1LAST_B CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll ---------------------------------------- RSConfigTool Assembly Version: 15.0.0.0 Win32 Version: 15.0.1103.234 CodeBase: file:///c:/program%20files/microsoft%20power%20bi%20report%20server/shared%20tools/rsconfigtool.exe ---------------------------------------- System.Windows.Forms Assembly Version: 4.0.0.0 Win32 Version: 4.8.4150.0 built by: NET48REL1LAST_C CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System Assembly Version: 4.0.0.0 Win32 Version: 4.8.4001.0 built by: NET48REL1LAST_C CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Drawing Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- System.Configuration Assembly Version: 4.0.0.0 Win32 Version: 4.8.4190.0 built by: NET48REL1LAST_B CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- System.Core Assembly Version: 4.0.0.0 Win32 Version: 4.8.4180.0 built by: NET48REL1LAST_B CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll ---------------------------------------- System.Xml Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- System.Management Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Management/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Management.dll ---------------------------------------- Microsoft.ReportingServices.Editions Assembly Version: 2020.5.0.0 Win32 Version: 2020.5.6.15 CodeBase: file:///c:/program%20files/microsoft%20power%20bi%20report%20server/shared%20tools/Microsoft.ReportingServices.Editions.DLL ---------------------------------------- System.ServiceProcess Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceProcess/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll ---------------------------------------- Accessibility Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll ---------------------------------------- System.Data Assembly Version: 4.0.0.0 Win32 Version: 4.8.4190.0 built by: NET48REL1LAST_B CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll ---------------------------------------- System.Transactions Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll ---------------------------------------- System.EnterpriseServices Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll ---------------------------------------- System.Numerics Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll ---------------------------------------- ************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box.
Solved
Anonymous
5 years ago Place Report Server
6.7KViews
0likes
6Comments
Direct Query Connection - Increase in number of connections in database
Hello Everyone, I am using direct query to connect to SQL database. Off late, i have observed that with direct query mode, each visual of report is consuming individual database connection and ending up creating mutiple connections to load a single report. However, this is not applicable to Slicer visual but for rest of the visuals i see this is happening. Can any one help me in optimising the number of connections getting created in database using direct query. Please see that to support the architechture, i need to go for direct query mode. Thanks, Kiranmai
Kiranmai-1
6 years ago Place Report Server
552Views
0likes
0Comments