database

14 Topics

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
685Views
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
813Views
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
Comparing the contents in 2 powerbi report servers
Hi everyone, I am checking if there is any way to run a query on the powerbi database to checko if all the contents in one powerbi report server is in another server. Thanks
Solved
Anonymous
6 years ago Place Report Server
820Views
0likes
1Comment
Facebook Database
Hi friends I am new to Power BI when I try to find facebook database in the Get Data "Online Services" but in there haven't facebook database can i know how to caonnect it to power BI
MaheshaDilhani
6 years ago Place Custom Visuals Development Discussion
3.2KViews
0likes
6Comments