KPI does not refresh
Howdy, I have a similar problem to this one: https://community.powerbi.com/t5/Report-Server/KPI-s-fail-to-refresh-sometimes-BUG/td-p/207249 We are running Jan 2019 PBIRS Yesterday, I added a KPI to our PBIRS front page that reports the number of report failures for the day (with trend). This morning the KPI was showing "1" although there were no failures. The corresponding tabular report linked to the same shared dataset shows the correct data. I used VS 2017 to generate toe datasource, dataset and tabular report and published directly from VS to PBIRS. I then added a second identical KPI and it shows the correct data: "0". Is this a bug? Do KPI's from shared datasets actually work? Any tips for getting this working?
Prevent part of dataset refreshing during scheduled refresh
Hi I am uploading data from a number of excel files into the dataset but alot of the data is static and does not need to be refreshed once it has been uploaded. When i schedule a data refresh (import) in the report server can i switch off which data sources i don't need anymore, the schedule refresh seems all or nothing Tim
Power BI Report Builder Error
I have a report which I've transitioned to Power BI Report Builder from Report Builder 3.0. I've set everything up the same as it was on Report Builder 3.0 with the exclusion of a dsDefaultDates dataset. Originally they wanted it from the beginning of the previous month to the end of that month to now wanting it to cover the last years worth of new accounts. (See queries below) Unfortunately, when I hit "Run"...the first page shows up just fine, but then if you keep scrolling or hit the arrow to go to the next page; I get an error, "An error occurred during local reporting processing". Is there a log file somewhere which can provide me a bit more of a detailed reason as to the cause of the error? Report Builder 3.0 dsDefaultDates dataset query: select trunc(trunc(sysdate,'MM')-1,'MM') StartDate, trunc(sysdate,'MM')-1 StopDate from dual Power BI Report Builder dsDefaultDates dataset query: select trunc(sysdate)-366 StartDate, trunc(sysdate)-1 StopDate from dual; Power BI Report Builder Installed Version: 15.6.1628.2Collapsing Fields and Visuals - MEMCM/SCCM Reporting
Hi all - This may be an elementary question as I've recently started diving into SCCM reporting using Power BI. Please advise if I'm not posting in the correct area. I've been able to create some useful visuals so far, but with simple single datasets. What I have now is a table that pulls duplicate values in a few columns (resource ID, net bios name). In SQL/SSRS, I'm able to collapse the values. For example, my query looks for any device in our environment that has a required MS update that is not installed, and will generate a compliance status of "Not Compliant" and so-forth. Because of this, I'm having trouble creating a visual where it shows correct numbers. Here's what I see in SSRS: I have it structured to expand by machine name. Here's what I have in Power BI: Here, each resource ID and machines name is associated to each update value. I'd like to create a visual of the overall compliacne of only one machine, say "count of machines where = compliant or not compliant". Can someone help give me a nudge on this one? Thank you!
Cant get SQL queries from PBI Report Server database
Hi experts, I am trying to find SQL queries wihch are the source of the micro data for the PBI reports storred in ReportServer database. I found this conversationWhere Can I find the published report in PowerBI Server usefull, but does not cover all my needs. Does anyboady know how to convert ReportServer.dbo.CatalogItemExtendedContent.Content field where ContentType='CatalogItem' to get the data source SQL queries or how to change powershell script from Anonymous in link above to get the content of the DataMashup file from the PBI.zip file? Thanks in advance, Jerneja
Weekly Report Refresh
Hi, We have a sales report that we currently use in excel. The data is relatively large (10,000+rows by 30columns) and will only grow as new enquiries come in. I have imported last weeks file into Power BI and cretaed a report and published it. It works great but now i want to put this weeks data in to Power BI. When i create a new dataset i cannot update the current report(maybe i am missing something simple). I have to either create a new report or save over the datatset file i used to create teh report. Is there anyway i can just import the new sales file and link it to a report tempate and we can do this weekly. Thank youRe-Using report data set in Report server
Do we have report dataset available in Report server once report is published/saved to report server? We have this is PBI service where we can directly create a report from dataset. Can we do something similar in Report server? Currently I saved report1 to report server, but if i want to create a new report2 based on dataset that we already build for report1 how can we acheive this?
