/
Export Database View

Export Database View

Starting from Power BI Connector 1.5.5 export of Database View functionality was added.

This option is available for ServiceNow Admin only.

Database View can be added on the data source page and easily export to PBI desktop.

Click on Add Source button and select database view from the list:

add_datasource.gif
app_on_server.gif

When Databse View is added it is possible to select fields (Referenced fields included), set Use display value option, set Filter string to get more accurate data.

Also, all general options and fields are supported to set on a data source with database view(s), such as Name, Description, Rows Limit, Use field labels for column names, and Disable editing for other users.

To export Database View data use the process, described in the article User Guide | How to import data into Microsoft Power BI

Related content

Use a dot-walking mechanism to export Reference type data
Use a dot-walking mechanism to export Reference type data
Read with this
How to get data from Variables type
How to get data from Variables type
Read with this
Data Source Page Overview
Data Source Page Overview
Read with this
Show Table(s) Schema Map data source option
Show Table(s) Schema Map data source option
Read with this