Starting from Power BI Connector for ServiceNow version 1.4.1 new 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:
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:
Now the user only needs to save the data source and export it to Power BI.
In some cases, reports do not contain fields, so it will be necessary to select preferred fields in order to be able to save data source and export data:
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: