Dataverse table is showing empty in Power Bi

[amank]

I tried importing, direct query, clearing cache, clearing permissions, rebooting the laptop and closing and opening desktop but nothing seems to be working, table is showing 0 rows, I ran sql query, it clearly has data but power bi is not loading for some reason. Please help!

[amank · Accepted solution]

@lbendlin Thank you!, I had to try to connect to datasource differently, Instead of connecting via Dataverse, When I connected via Common Data Service, I was able to see the data. So weird but worked 🙂

[lbendlin]

clear the global permissions for that connection and then refresh the preview again (re-authenticate when asked).