Forum Discussion

amank's avatar
amank
Frequent Visitor
4 years ago
Solved

Dataverse table is showing empty in Power Bi

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!

 

Need Help
  • amank's avatar
    amank
    4 years ago

    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 🙂

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

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

  • amank's avatar
    amank
    Frequent Visitor
    4 years ago

    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 🙂