User Profile
achanikya
Helper I
Joined 5 years ago
User Widgets
Contributions
Re: SAP Business Warehouse Message Server data source not supported on Power BI report server?
yashsharma20 Hello! Connecting to an SAP Business Warehouse Message Server data source on Power BI report server can be challenging at times. Here are a few troubleshooting steps that you can try to resolve the issue: Ensure that the latest SAP Business Warehouse ODBC driver is installed on the Power BI report server. You can download the driver from the SAP website. Check whether the Power BI report server is running the same version of the SAP Business Warehouse Message Server as the one used by the Power BI Desktop application. If not, you may need to upgrade or downgrade the Message Server version to match the Power BI report server. Verify that the necessary ports are open in the network infrastructure to allow communication between the SAP Business Warehouse Message Server and the Power BI report server. You may need to work with your network administrator to confirm that the appropriate ports are open. Try connecting to the SAP Business Warehouse Message Server data source using a different client tool or application, such as Excel or SQL Server Management Studio. If you encounter issues with other client tools, it could indicate a problem with the SAP Business Warehouse Message Server setup. Check whether there are any known issues or limitations when connecting to SAP Business Warehouse Message Server from Power BI report server. You can review the documentation or support resources from both SAP and Microsoft to see if there are any specific configuration requirements or limitations. If none of the above steps help to resolve the issue, you may want to reach out to your SAP or Microsoft support team for further assistance. They may be able to provide additional insights or solutions to help you connect to the SAP Business Warehouse Message Server data source on Power BI report server. I hope this helps!Re: selectedvalue/allselected for multiple values
Anonymous Anonymous The reason why your measure is only able to select one value is that it uses the ALLSELECTED function, which returns a single value when multiple items are selected in the slicer. To allow for multiple values to be selected in the slicer, you can modify your measure to use the VALUES function instead of ALLSELECTED. Here's an updated version of your measure: Q3 TEST3 = CALCULATE( COUNTROWS('Q3'), FILTER( ALLEXCEPT(Q3, Q3[Gender], Q3[Age], Q3[Employment], Q3[Tenure]), Q3[Facility Name] IN VALUES(Demographics[Facility Name]) ) ) This modified measure uses the IN operator and the VALUES function to filter the data based on the selected values in the Demographics[Facility Name] slicer. The VALUES function returns a table of the selected values in the slicer, which can include multiple values. Once you have updated your measure, you can use it in a bar chart visual along with the Demographics[Facility Name] field in the Axis section to create the bar chart you desire.Measure Calculations decimal point
Hi team, Here I am trying to calculate the measure value TCS_AMT. The following is the query that we have used in DB. Sum(( (Nvl(Nvl(T502.C502_Ext_Item_Price,T502.C502_Item_Price),0) * Nvl(T502.C502_Item_Qty,0))+ ((Nvl(Nvl(T502.C502_Ext_Item_Price,T502.C502_Item_Price),0) * Nvl(T502.C502_Item_Qty,0))* Nvl(T502.C502_Igst_Rate,0)/100) + ((Nvl(Nvl(T502.C502_Ext_Item_Price,T502.C502_Item_Price),0) * Nvl(T502.C502_Item_Qty,0))* Nvl(T502.C502_Cgst_Rate,0)/100) + ((NVL(NVL(t502.c502_ext_item_price,t502.c502_item_price),0) * NVL(t502.c502_item_qty,0))* NVL(t502.c502_sgst_rate,0)/100)) * Nvl(T502.C502_Tcs_Rate,0)/100) As TCS_AMT The calculation that I used in power BI Desktop was Created all the measures for IGST,GST,CGST .We are expecting the value for the TCS_AMT ="5015.775" and we are not supposed to use 1000 divider for the above formula.Could anyone of you please let me know the solution for this.
