Skip to main content

Power BI

New

Data connection change - when trying to get data from SharePoint lists

Vote (1) Share
Nikhil's profile image

Nikhil on 10 Apr 2017 18:08:20

Hi,

We are fetching data via 'Direct Query' option using the Azure Data base, then we discovered that we needed some data from the Sharepoint Online Lists too.

But when we tried to fetch data from the Lists, the data connection changed from 'Direct Query' to 'Import'. Not sure why this is happening.

We should be able to fetch data using direct query and not force us to import