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
I found a workaround using the JQY query url generated by sharepoint when you "Export to Excel" from sharepoint and using that in the web connector. Works find for site collections when I have Admin Rights but won't work when I try to use lists/views in collections that I only have full admin permissions to access. I can usually get it work using the SP List Connector or a JSON query but each of these require significant manipulation to transform the data. When using the JQY query url in the Web connector it very easily imports just the details for the view I'm looking at including any calculated columns, values for person records etc.. The implementation within Excel works great and I can use the resulting table as a data source, however when trying a powerquery solution I get the permissions errors unless I have permsissions to access the VTI_BIN SP Application folder.
