PowerBI supports pulling data from SharePoint lists but only from the default view. My business has tons of views set up. We need to use those views directly in PowerBI
On SharePoint, you have the option to export a list to an Excel or Access file to work with the data. Excel and Access maintain a connection to the SharePoint list, and you can refresh at anytime. You may also export a personalized view, with only the columns you want, in the order you want, and further filtered by other view parameters you set. It would be great to have an export to .pbix file option to establish a connection to a particular SharePoint list/view. Currently the workaround is to export a SharePoint list/view to Excel or Access, then connect to that file using Power BI Desktop. This would remove that step and create an active and refreshable connection straight from the SharePoint list.
