power bi help
4 Topics
On premise gateway logs - Dataset and Gateway connecton
Hello, We have a Power BI On Premise gateway server. I can loginto the server and run the Gateway Performance Monitoring Pbit file (Monitor and optimize on-premises data gateway performance | Microsoft Docs) which gave me information such as datasource type, the query executed, excution length. What I need is the Dataset name and who configured the scheduled refresh. When I look Gateway performance template report and notice some long running queries I want to inform the user of the dataset but I cant find that information. I may be missing something. The fields does not have any Dataset or user names. I thought this would be easy information to find but found out its not. How do you admins maintain /monitor your on premise gateway performance. Thanks,Solved7.6KViews0likes6Comments
Row Level Security using AD-ENT group
Hello, I have a PBI model and want to do Row Level Security. I don't want to do this creating roles; instead I am hoping this can be done using AD groups. We currently have one AD group that people get added to when they want to view our dashboards. I would like to create an additional AD group which would restrict the records people in this new AD group have access to. I would like to create a simple table of two columns - 1. the AD Group, and 2. An Indicator. The indicator is the field I would use to determine what the AD Group has access to; it would have values of 0 or 1. I would add this table to the model and join it to the fact table by the Indicator. When a person views a dashboard, they would then either be restricted from seeing some records or be able to see everything based on the indicator and what AD Group they are in. Is this possible? I've been playing around with AD tables but I haven't seen any field values that match with our AD Group names. Thanks!Solved1.9KViews0likes4Comments
Need some help with methodology - calculate time in status of ordered list
I think this might be a simple question for many. I have a table MyTable( status (INT) , Modified(DateTime) ) The statuses are ordered, but can be duplicated with multiple dates. I am looking to show how long they are in each state, with the end goal to be aggrigating and charting Average time in a given status. Can anyone point me in the right direction on methodology? Input table Status Modified 1 1/1/2020 2 1/3/2020 2 1/5/2020 3 1/6/2020 4 1/7/2020 Desired result Status TimeInStatus 1 2 (days) 2 3 3 1Solved1KViews0likes2Comments
