Add additional data in excel file
I'm new to Power Bi, but was able to develop a report in PowerBi Desktop using data from Excel File saved in OneDrive. However, after completing the report, I realized that I added one new extra columns in my Excel file. I'm now trying to update my data in PowerBI after adding the columns in the original Excel file, but I can't see the columns. I did refersh as well but still it is not showing in the report data? Could anyone please help me, thanks
Is it possible to get report error message that display when someone open the report?
I created an API alert system that would alert report PIC about the error through telegram, the thing is the detail error message only available for data refresh but not for user execution error. I tried looking in execution log 2 & 3 but no luck, all I can get is execution status and additional info. I tried looking in log file but no relevant information was found either. So my question is, is it possible to get the report error message that occured when someone viewing the report. TLDR; I want to get above error message, ideally from report server database tables. Is it possible? Thanks.
Help with building abnormal PSA Follow up report--PLEASE
PSACheck - Power BI Report Server (va.gov) I transferred from Southern Nevada in Visn 21 to West Texas in Visn 17 and have been disheartened to discover how limited we are with access to data. I am attempting to duplicate some of the processes from my old site and need assistance in building a PSA Follow Up report. I have attached the link to the VASNHS. How would I go about having this developed for West Texas? Thank you.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.
Publish dataset
some question concern on Publish dataset 1) it is safe to publish the data set to the Power BI service as having some security concerns data set like patient data? 2) can anyone view or download the dataset once is Publish in the Power BI service? 3) is there any other way to view full view and share with the team without Publish to the Power BI service web portal etc in my local computerHelp me to understand the refresh of the data
Hi, I have build a PowerBI solution for my client with a PowerApps Canvas to update some data in my Azure Sql Server. Technically, it works and I can see the update directly in my Sql Serveur. But in my reports, the update is not visible. For instance, here the screenshot of the number of items I have in PowerBI desktop (the refresh of the data has been done manually) But in PowerBI web, I still have the previous result I need explanations to understand what is the logic behind and also, how long I have to wait to see the result in PowerBI Web. Thanks
Power BI Report
Добрый день! Прошу подсказки. Имеется 2 датасета. В первом - полный список инженеров группы. Во втором - активность инженеров за определенный период. На общей диаграмме хотелось бы видеть процент загрузки группы от рабочего времени. При этом список инженеров из первого датасета добавлен в фильтр, соответственно можно их выбирать. Но. Если у инженера не было загрузки за период, то в списке он остается, а вот в выборку по загрузке не попадает. Соответственно его выбор\отмена выбора в фильтре никак не изменяет общий процент загрузки группы. Подскажите пожалуйста, как сделать так, чтобы общая загрузка считалась процентом не только от инженеров, у которых была активность, но от всех из первого списка. Спасибо!
