Skip to main content
Microsoft Idea

Power BI

Needs Votes

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

Vote (3) 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

Comments (1)
Nikhil's profile image Profile Picture

Magnus Hellstrand on 19 Jan 2021 09:16:27

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

Sounds like the same request as in https://ideas.powerbi.com/ideas/idea/?ideaid=0c9dd6af-11a4-479a-9f87-987185e15df1 with currently 328 votes.