Forum Discussion
Ways of Working Assessment Dashboard (Temporary File Size Issue)
Hi kb2010,
We have designed Power BI templates to help Viva Insights users with the most common setups and business scenarios. For best results, use the following guidelines for selecting the parameters while setting up the templates for Power BI:
- Limit the number of employees included in your query results to 50,000 or less.
- Select the last six months or less for the time period.
- Include up to seven organizational attributes in your query, including the required ones.
Check out this article in our documentation site with a few more suggestions: Power BI tips, troubleshooting, and FAQ | Microsoft Docs
I encourage you to think of the use case for the report you are trying to set up and scope it to the right population, time period, and only those dimensions (organizational attributes) you need for your analysis.
You can also consider initializing the template in Power BI Desktop with a reduced dataset: you may run your Viva Insights queries for just the last 1 month, include a few employees and a few organizational attributes. Once you initialize the template, you can publish it to the Power BI service. You can then run your Viva Insights queries using the intended parameters (population, time, and organizational attributes) and change the OData URL links in the data source in the Power BI service. Finally, you can refresh the report in the service. You can also consider publishing the report to a workspace in a Premium capacity.
MicrosoftHi kb2010,
We have designed Power BI templates to help Viva Insights users with the most common setups and business scenarios. For best results, use the following guidelines for selecting the parameters while setting up the templates for Power BI:
- Limit the number of employees included in your query results to 50,000 or less.
- Select the last six months or less for the time period.
- Include up to seven organizational attributes in your query, including the required ones.
Check out this article in our documentation site with a few more suggestions: Power BI tips, troubleshooting, and FAQ | Microsoft Docs
I encourage you to think of the use case for the report you are trying to set up and scope it to the right population, time period, and only those dimensions (organizational attributes) you need for your analysis.
You can also consider initializing the template in Power BI Desktop with a reduced dataset: you may run your Viva Insights queries for just the last 1 month, include a few employees and a few organizational attributes. Once you initialize the template, you can publish it to the Power BI service. You can then run your Viva Insights queries using the intended parameters (population, time, and organizational attributes) and change the OData URL links in the data source in the Power BI service. Finally, you can refresh the report in the service. You can also consider publishing the report to a workspace in a Premium capacity.