Power BI Connector for Shopify

Build 25.0.9454

Menus

Lists navigation menus used on the storefront.

Table-Specific Information

Select

The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.

  • Id supports the '=, IN' comparison operators.
  • Title supports the '=, !=' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM Menus WHERE Id = 'Val1'
  SELECT * FROM Menus WHERE Title = 'Val1'

Insert

The following columns can be used to create a new record:

Title, Handle, Items

Update

The following columns can be updated:

Title, Handle, Items

Delete

You can delete entries by specifying the following column:

Id

Columns

Name Type ReadOnly References Description
Id [KEY] String True

A globally unique Id for the menu.

Title String False

The title of the menu.

Handle String False

The handle of the menu.

IsDefault Bool True

Indicates whether the menu is a default. The handle for default menus can't be updated, and default menus can't be deleted.

Items String False

A list of the menu's items, sorted by position.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454