cancel
Showing results for 
Search instead for 
Did you mean: 
0

Issue publishing narratives

Narrative that are working in local version of the report, when published do not work anymore (2 out of 3).

 

The error I'm getting for both visuals is:

Couldn't load the data for this visual

Query (206, 5) Correlation coefficient should be between -1 and 1. Input:-1

Please try again later or contact support. If you contact support, please provide these details

 

Activity ID: 135d9bcc-0398-429e-82cc-b8c7ffb199a8
Request ID: 99f47a44-4b20-0241-f7b5-339030829874
Correlation ID: fbfb1434-942f-6ff7-baf7-739fa2dce5f7
Time: Fri Oct 22 2021 10:12:59 GMT-0400 (Eastern Daylight Time)
Service version: 13.0.16982.45
Client version: 2110.2.08110-train
Cluster URI: https://wabi-us-east2-redirect.analysis.windows.net/

Status: Delivered

This issue needs troubeshoot with an engineer from Power BI support Team.

Comments
v-cazheng-msft
Community Support
Status changed to: Needs Info

Hi @sebano 

 

There are several considerations and limitations when you using narratives. Please check whether there is an item applicable to your issue.

Considerations and limitations

The smart narrative feature doesn't support the following functionality:

  • Pinning to a dashboard
  • Using dynamic values and conditional formatting (for example, data bound title)
  • Publish to Web
  • Power BI Report Server
  • On-premises Analysis Services
  • Live Connection to Azure Analysis Services or SQL Server Analysis Services
  • MultiDimensional Analysis Services data sources
  • Key influencers visual with a categorical metric or unsummarized numerical field as 'Analyze' field from a table:
    • that contains more than one primary key
    • without a primary key, and measures or aggregates as 'Explain by' fields
  • Map visual with non-aggregated latitude or longitude
  • Multi-row card with more than three categorical fields
  • Cards with non-numeric measures
  • Tables, matrices, R visuals or Python visuals, custom visuals
  • Summaries of visuals whose columns are grouped by other columns and for visuals that are built on a data group field 
  • Cross-filtering out of a visual
  • Renaming dynamic values or editing automatically generated dynamic values
  • Summaries of visuals that contain on-the-fly calculations like QnA arithmetic, complex measures such as percentage of grand total and measures from extension schemas.
  • Calculation groups

 

Best Regards,
Community Support Team _ Caiyun

sebano
New Member

Are you saying that  I can only use Narrative in the local version of the report and I cannot publish? Because the issue is coming only when I publish. In local my 3 narratives work fine and update fine. When I publish 2 out of 3 give the error.

 

v-cazheng-msft
Community Support

@sebano 

 

You can publish report with Narrative, but there are some considerations and limitations as I mentioned earlier when you using it. If there isn't any item applicaple to your issue, please open a support ticket for 1:1 troubleshoot by this link.

 

Best Regards,
Community Support Team _ Caiyun

v-cazheng-msft
Community Support
Status changed to: Investigating
 
v-cazheng-msft
Community Support
Status changed to: Delivered

This issue needs troubeshoot with an engineer from Power BI support Team.