Versions Compared

Old Version 2

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version Current

changes.mady.by.user Sarabjeet Kaur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Applies to: (tick) Kyvos Enterprise  (tick) Kyvos Cloud (SaaS on AWS) (tick) Kyvos AWS Marketplace

...

  1. Go to published semantic model > Settings > Gateway and cloud connections. Navigate to the Gateway connections section, select the connection if already created. Otherwise, select the gateway, in the Actions column, click the View Datasources button.

  2. The Datasource included in the semantic model section is expanded:

    1. If you view the Add to Gateway link, click the link and it will display the New Connection pane. Perform the Step 4 and Step 5, as mentioned above in this section.

    2. If connection is already created in the gateway, from the Maps to list, select the created connection. Otherwise click the manually add to gateway option from the list and then perform Step 4 and Step 5, as mentioned above in this section.

    3. Select Apply.

    4. Now open the published Power BI workbook.

...

You may encounter the following limitations when performing data analysis and visualization tasks after setting up Spark SQL connectivity in Power BI. These will be fixed in the upcoming versions.

  • You cannot apply a measure filter if that measure is not part of the Kyvos visualization. To do so, you need to create a calculated measure using the desired measure, and then you can use that calculated measure in the filter. This is required because when we place the measure in the filter, it sends an unaggregated query to the Kyvos. 

  • Kyvos does not support conditional formatting using the 'field value' format style 

  • Following Kyvos features are not supported: 

    • Scope Script

    • Unconditional Masking

    • Default Member Script

  • Key influencer is not working. This is a known limitation of Power BI on direct query. For more information, see Microsoft Power BI documentation. 

  • Conditional formatting for the field value and icons is not working due to Power BI handling issue.

  • Sorting of month is not displaying as per the nomenclature because Power BI itself handles sorting.

  • Power BI generates queries in a such way due to which a user might get data inaccuracy or may get extra records in the case of topN query.

...