data connection method switching from direct query to import when trying to add data from sharepoint online
We were working on a powerBI report using Direct query connection(we are using azure sql db)
We then tried to add additional data from the SharePoint Online lists, Although we were able to get the data successfully, the data connection was changed from direct query to import.
and then we were never able to go back from 'import' to 'direct query'
Can anyone help me with this