database
16 Topics
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.Solved6.7KViews0likes6Comments
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!Solved6.1KViews0likes14Comments
Data Source on uploaded report greyed out and not working - Oracle
Hi, I am wondering if somebody can give me some advice.... I have created a simple test report on the desktop version of Power BI which hits my Oracle database fine. Saving the same report on a Power BI Report Server and running it does not work even though the tnsnames information is correct. I have also noticed that the data source settings with in the report are greyed out: However, I can create a data source on the Power BI Reporting server and test it fine: I am fairly confident therefore the Oracle client info and tnsnames.ora server side are OK. How do I go about playing with the data source on the uploaded report if it is greyed out? Any help would be greatly appreciated. CheersSolved4.7KViews0likes2Comments
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?4.1KViews6likes7CommentsIs 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.Solved2.5KViews0likes2CommentsProblems installing the EXASOL Database Connector
Hello, im working the first time with Power BI and I installed Power BI Desktop (July 2017 - normal Desktop Version). Im also using the EXASOL Database, so therefor I installed the EXASOL Microsoft Power BI Connector (Beta), which worked. But now Im using Power BI (October 2017- optimized for Report Server) and I tried to install the EXASOL Connector again but it doesnt work. Is there any solution to install the EXASOL Connector or to continue to use the EXASOL Database? I followed the installation steps on github (for the exasol connector) but the problem starts at the point when I have to enable the Custom Connectors. If I open "Option and settings" -> "Options" then Power BI dont give me the options to click on "Preview features" and to enable "Custom data connector". Are there any other Steps to enable the Exasol Connector? Or do I have to use the ODBC Connection? Thanks NikaSolved2KViews0likes2CommentsRefresh taking multiple licenses for custom database
Hello, I'm developing a dashboard for the company that I currently work for. I'm getting data from a licensed database that we own, and we currently own 24 licenses for that database. However, whenever I refresh the data in Power BI, it uses up as many licenses as it can. Is there a setting where I can refresh each table one at a time using the same license? Thank you for your responses!1.3KViews0likes4CommentsHow 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 advanceSolved1KViews0likes2Comments
