Versions Compared

Key

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

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:

Image RemovedImage RemovedImage Removedadd_datasource.gifImage Addedapp_on_server.gifImage Addedadd.gifImage Addedadded.gifImage Added

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 https://aserve.atlassian.net/wiki/spaces/PBISN/pages/2433581072/User+Guide#How-to-import-data-into-Microsoft-Power-BI?