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....Manager 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?Person 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ïeterMeasured 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? Thanks
Viva 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 MHGroup 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.How 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 Thanks
