DAX Calculations for representation of percentage change from the previous day
Hello experts! I am still learning Power Bi and a beginner. I am trying to track daily performance of all the stores. Please help me in finding the percentage change from the max date to a day before max date for each store. Here the "Daily Input" is constant, rarely changes and "Outputs" values varies daily with new dates updated. A sample raw data with calculations and expected outputs are available in the link https://docs.google.com/spreadsheets/d/1Fi5d1TV3sV-4QZzjEggFDChg7n11cgaciVknF76GYwk/edit#gid=709207873 Output: Formulae used: Thank you for your support and efforts in advance!!Finding daily improvement for each product
Hi Experts! I am trying to figure out how to do something but cant quite grasp it, can someone help me? I want to track the "Improvement status" every day for the each product as explained in the "Desired results". To arrive "Improvement status" , I have calculated "Selling Price/Cost", "Day's Selling/Cost", "Gain". Also took the help of "Calculated table" for "Total cost" , "Total selling price" and "Day's Selling/Cost" of all the products per day as shown in the images. Please use url for raw data(data adds every day) and calculations ( https://docs.google.com/spreadsheets/d/1IfOjW_175gu1wC82Nb7CSGsSdtiXQm3tr4NcEhqrays/edit?usp=sharing) Data: Desired Result (Improvement Status) : Thank you in advance!!
Lookup error for session ID using report server DB or API
Hi, We are using SSRS APIs to create refresh plan schedule for PBIX report on PBI report server. And we get the last run status but it does not return details. Data Refresh failed, contact the administrator, SessionId: dd13d7bf-56ef-4eed-865a-de6f67d3a50e. We do have the session ID and if we search for it in report server logs then we find the details. Also we can see details if we go to refresh plan details on report server UI. Details in SSRS log: Data Refresh failed, contact the administrator, SessionId: dd13d7bf-56ef-4eed-865a-de6f67d3a50e. Details in refresh plan UI: But we want to show this info on our web application. We already tried searching report server DB (tables, executionlog views, etc) for these details but did not find any thing. Where can we find these information/details other than reporting services logs? Any API or DB table?
Get the average of a column value based on total count of values in ID column
Hi, In a table i have column called "Object" which runs multiple times in a day and that runtime is captured in "StartTime" & "EndTime" columns, and the difference between the start and end time is captured in the "Duration" Column. Each object will be having multiple runid's which is captured in "RunID" column which is a unique value. For eg: Object AAA has two runid's called "111,222" and Object BBB has one runid called "333". Now i would like to get the average of each duration by count of that particular runid which is captured in "New Duration" column. For eg: The count of 111 runid is '10'. so for all those durations with runid 111 should be divided by the 10. The count of 222 runid is '6'. so for all those durations with runid 222 should be divided by the 6. The count of 333 runid is '8'. so for all those durations with runid 333 should be divided by the 8. Sample screenshot for above query: So since my Duration is "10" and total count of runid (111) is 10. So 10/10=1 that is my newduration.Similarly for all durations with runid's 111 should be divided bt 10. How to achieve this using DAX query?? I am connecting to this table in powerbi via SQL direct query mode. Thanks.Cannot Render PBIX reports - Get An Error has occurred.
Today we have been getting the generic error - "An error has occurred" when trying to render reports on power bi server. I looked at the log files and I see a lot of "ERROR 53 OData exception occurred: System.Net.WebException: The remote server returned an error: (401) Unauthorized." I have done a lot of research but I haven't seen anything that can help me. Any help would be much appreciCannot upload PBIX file on fresh install of PBIRS
Hi, we recently aquired a separate testing environment for our project, so we installed a new VM with SQL Server 2017 (same as production) but as developer edition (not sure if relevant). On it we installed Power BI Report Server 15.0.1103.232 x64. We configured a service account from our domain, configured the web service url and database. The portal works fine, but as soon as we tried to upload our pbix files from the other environment or even simple dummy files we always get the same error: (translated) Error uploading the PBIX file. Check if the file is damaged and if the extension matches the content of the file. (german original) Fehler beim Hochladen Ihrer PBIX-Datei. Überprüfen Sie, ob die Datei beschädigt ist, und stellen Sie sicher, dass die Dateierweiterung dem Format der Datei entspricht. If I check the browser developer tools I see that a request to a service fails with HTTP 422 (Unprocessable Entity) Name Protocol Method Result Content type Received Time Initiator http://[servername removed]/reports/api/v2.0/catalogitems HTTP POST 422 application/json 235 B 55,55 ms The same happens if I try to upload through Power BI Desktop (the Report Server Version 2.81.5831.1181 x64, as downloaded from the portal-site) but with different error message: An error occured while attempting to save the report to Power BI Report Server. The Portal-Logfile shows a "forbidden" error: 2020-09-11 13:16:36.3110|INFO|64|Received request GET /api/v2.0/System/Properties| RequestID = s_539fdc5e-b610-4eb4-82d8-1229ee540610 2020-09-11 13:16:36.3110|INFO|64|Sending response. Response code [removed user name] 200, Elapsed time 0:00:00.0063115| RequestID = s_539fdc5e-b610-4eb4-82d8-1229ee540610 2020-09-11 13:16:36.6408|INFO|64|Received request GET /api/v2.0/me| RequestID = s_0e1e4a8d-f940-4dcb-8997-17eb4cbe2d9a 2020-09-11 13:16:36.6720|INFO|64|Sending response. Response code [removed user name] 200, Elapsed time 0:00:00.0289183| RequestID = s_0e1e4a8d-f940-4dcb-8997-17eb4cbe2d9a 2020-09-11 13:16:36.7502|INFO|64|Received request POST /api/v2.0/powerbireports(Path='/sample')/Model.Upload| RequestID = s_a1f0ea50-22a6-4ee7-b109-918fd408f22c 2020-09-11 13:16:36.8127|ERROR|65|The remote server returned an error: (403) Forbidden.| RequestID = s_a1f0ea50-22a6-4ee7-b109-918fd408f22c 2020-09-11 13:16:36.8127|INFO|67|Sending response. Response code [removed user name] 422, Elapsed time 0:00:00.0611536| RequestID = s_a1f0ea50-22a6-4ee7-b109-918fd408f22c I know there are numerous reports to the same error, but all suggested solutions did not work and most were for older versions and I often read that the compatibility between versions is an issue, so I don't know how relevant these are to the current may 2020 version. I restarted the service (and reinstalled the reportserver including deleting report databases) multiple times. I use a domain account as service-account. I even tried granting it local admin privileges (testing environment, so...) The portal runs (by now) without https, so it should not be certificate stuff... The test files are small (<1mb) and can be uploaded to our production server just fine. The command "netsh http show urlacl" shows my site registration correctly. I am really out of ideas what I can do and "msdn subscriber" support pointed me here... I hope anyone of you does 😄 Best regards Sebastian
