Forum Widgets
Latest Discussions
I cannot get the Power BI Connector to Work - Data Table Shows Up Blank
I have 230 paid licenses in WPA right now. I run WPA queries and everything shows up fine. I am new to Power BI and want to bring some data over from WPA to Power BI. I followed these instructions exactly several times. https://docs.microsoft.com/en-us/viva/insights/use/view-download-and-export-query-results#connect-through-the-power-bi-connector. Once I run the connection the data table in Power BI shows up with all the expected column headers but ....no data. It also looks slightly different than the data table wizard in the instructions because it doesn't have a folder structure next to it. How do I get this connector to work? Note: I successfully navigated from the pre-built viz on the Home page of WPA over to Power BI which works fine except it only brings over the variables needed for that particular viz and I want to bring over all the variables so I can start my own viz. As I said I am new to Power BI and some of the pre-built viz are beyond my skill level at the moment. Thanks to anyone who can help! My table after connecting....VI_MigrationOct 22, 2021Silver Contributor5.3KViews1like12CommentsClarifying meeting hour value
Hi Community, My colleagues and I were trying to reconcile the Audio minutes in Teams Admin Center with the meeting hours within Advanced Insights, and I wanted to clarify how meeting hours are calculated / retrieved. Is it just the scheduled length of the meeting in Outlook? i.e. I have a 1-hour block, which is a Teams meeting, during which my team and I spoke for 45 minutes (we ended early!). Within Teams admin center, I would suspect all our audio time would appear as 45:00, but would that meeting appear in my corresponding Person query as 1 meeting hour? Corollary to that, in the Meeting query, attendee meeting hours would be 1 hour * # of attendees? Thanks!SolvedVI_MigrationApr 05, 2022Silver Contributor5.4KViews0likes10CommentsManager Effectiveness template - can't refresh or identify dynamic data source after publishing
I've had this trouble for a while after publishing the Manager Effectiveness template; all the other templates seem to refresh fine, but I can't schedule refresh for this template. I get the below error - I thought perhaps the glossary connection was the problem, but disabling that didn't help. I can't see what Query1 is, so I'm not sure what the problem is. Perhaps it isn't a problem, and the report will still pull in the latest data?SolvedVI_MigrationMar 24, 2022Silver Contributor5.3KViews0likes9CommentsPerson query - missing metrics!
Hi, on the metrics definitions MS Docs page (https://docs.microsoft.com/en-us/viva/insights/use/metric-definitions) the following channel-metrics for Person queries are explained. Unfortunately, when creating a new Person query in Workplace Analytics, these channel-metrics are not in the drop down list. Does anyone else has this experience? Can someone please help me out? We urgently need these insights to compare it to email usage/habits. Hopeful regards, PïeterSolvedVI_MigrationDec 06, 2021Silver Contributor3.6KViews1like9CommentsMeasured Employee Count is Greater than Licensed Employees
Working with a customer and we recently noticed that the Measured Employee count being shown on PowerBI reports is significantly greater than the number of licensed employees. Has anyone else observed this, and are there any suggestions to correct this? ThanksVI_MigrationNov 29, 2022Silver Contributor3KViews0likes8CommentsTime investors vs Collaborators Directionality
Hi All trying to understand if there is directionality with these two in the person to group and group to group queries. e.g. If Person A Sends emails to Person B and Person B never responds say the collaboration hours amounts to 1 hour. In the query would this show up as - Time Investor (Person A) to Collaborator (Person B) Collaboration = 1 - Time Investor (Person B) to Collaborator (Person A) Collaboration = 0 Similarly if Person A schedules a meeting with Person B say 1 hour and Person B attend the meeting. However Person B has never set up any meetings with Person A. Will this also show up as: - Time Investor (Person A) to Collaborator (Person B) Collaboration = 1 - Time Investor (Person B) to Collaborator (Person A) Collaboration = 0 Essentially In the two examples above person B aced as a collaborator but never initiated anything with Person B. so the directionality of hte time investment is always Person a to Person B. Can someone confirm this. Jake_CaddesSolvedkb2010Jun 29, 2022Brass Contributor5KViews0likes8CommentsViva Insights query integration with enterprise systems
Currently we are manually accessing our Viva Insights queries using a Microsoft API to download the query result sets to our Enterprise backbone and one of our loads takes roughly 3 days to get executed and often time out. We are looking for a solution and are open to suggestions. - Is there a configurable API by date range that we can use instead of the current MS API that only allows us to access 10 K records at a time. - Are we able to get a query automatically generating a file that could be sent to us via SFTP. Looking to hear from you and this request is urgent. Thanks, Glen MHVI_MigrationMar 29, 2022Silver Contributor3.1KViews0likes7CommentsGroup to Group Query Metrics
Hi All a. What is the basis for limiting the number of metrics in the group-to-group query compared to the many more metrics available in the person query that could apply to group to group e.g. call hour, call count, IM hours, IM count etc? I also noticed whist email hours is included email count is not but for meeting hours there is both hours and count? I assume there a technical reason for this which I am not understanding? At present I need to manually create the query using rules in the person query and limited to a pair of groups as its very time consuming to set up. b. second pioint with respect to the Person to group query in addition to the same point above (which applies to this query too), why does the person to group query have metrics that arent available in the Group to group and vice versa? e.g. email count and network size not available in grop to group and time investors meeting hours not available in per to group query. (unclear about how to use network size and time investors meeting time in this context though). but key point is can we not have other relevant fields form person query e.g. IM and Call.kb2010Jan 20, 2022Brass Contributor4.7KViews0likes7CommentsUnscheduled 1:1 calls/chats
Is there a way to define/determine unscheduled 1:1 calls/chats between a manager and direct reports? I'm asking in the context of the "Ways of Working Assessment" template - the manager 1:1 assessment (page 15 of the report), runs analysis on meeting hours with manager 1:1. I would like to understand if unscheduled calls/chats can also be calculated for 1:1 time.SolvedVI_MigrationNov 10, 2021Silver Contributor7.7KViews1like7CommentsHow long is the lag between when the data is refreshed and the collaboration data
Hi folks I may be demoted as "superuser" for asking this but I'm noticing for some time now that my data is two weeks old despite auto-refresh switched on and my PowerBIs getting refreshed weekly or even ad hoc What I mean is, as am posting this it's Dec 9 13:20 CET time and the most recent collaboration data I have is Nov 28 I would have expected Dec 5 as that is when my last refresh was run Went into PowerBI and ran an ad hoc refresh just in case but didn't refresh any further I remember this was not the case a while ago. Is it the expectation that there's a two weeks lag now? In normal situations this is bearable but when we get urgent requests it's a hard one to sell that you have to wait for two more Mondays to get the data ThanksSolvedVI_MigrationDec 09, 2021Silver Contributor763Views0likes6Comments
Resources
Tags
- Power BI and query performance17 Topics
- Report templates14 Topics
- Ways of working8 Topics
- Custom queries7 Topics
- Metric customizations and rules7 Topics
- Wellbeing6 Topics
- Miscellaneous5 Topics
- Business leader inspiration4 Topics
- Organizational networks4 Topics
- Analyst workbench4 Topics