'User not authorized' error when connecting to sharepoint online list

I am trying to connect to a sharepoint online list through Power BI desktop. But when I select the list table and give organization credentials, it is showing 'User not authorized' error. I am able to access the list in Excel 2016. What could be the problem here?