Starting from Power BI Connector for ServiceNow version 1.4.1new option - create data source New from Report was implemented.
The reports list is taken from the ServiceNow Reporting application:
...
The list of selected fields in a data source is taken from the file configuration of Report edit page, and can be checked from ServiceNow Reporting application:
...
The New from Report button is located on the Dashboard page and visible for ServiceNow Admin, PBI Admin and PBI Editor roles.
...
Click on a button will open Dialog with Reports list:
...
The reports list is taken from the ServiceNow Reporting application:
...
After Report is selected, the user will be navigated to a new Data Source page with pre-filled fields: Name, Description, Export config, Filter and selected only report fields:
...
If needed, users can modify the Data Source (add more tables, rows limit, change filters, etc.). Changes will not be applied to existing Reports.
Please NOTE: Before export, users must check if all necessary permissions for data export are assigned. In case if not - the user will not be able to create Data Source:
...