New Dataverse Table not available to import data from

[Lexicaltje]

Morning all,

Have a very annoying problem... Created a new Dataverse table in my test envrionment last week (7 days ago). Even now the table does not appear on the list of tables i can import data from when connecting to a data source in Power BI desktop. I have no idea why!? I can access all my other custom tables in that envrionment (which were created about 6 months ago). 

I've tried publishing all customisations, clearing the Power BI desktop cached connections. Nothing is working. 

Honestly dont get it.... Anyone had a similar issue and fixed it? 

[Anonymous]

Hi @Lexicaltje ,
According to your description, there have been partners who have encountered a similar problem, and after their attempts, they found out that it might be due to data delays. You can try to clear the permission and re-verify your account.Go to Home Tab-> Transform Data -> Data Source Setting -> Clear permission and try again. you can get your environment URL again.

Solved: Dataverse Table not appearing in Power BI (powerplatform.com)
Solved: Can Not Find the Table in the Dataverse Environmen... - Microsoft Fabric Community
Solved: New columns added in Dataverse Table are not visib... - Microsoft Fabric Community

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Lexicaltje]

I've just cleared all permissions and the table still doesnt appear. 

[nleuck_101]

@Lexicaltje 

Did you ever get this figured out. I'm also having the same issue and have tried clearing my permissions.

[Lexicaltje]

Hi there,

Yes i did, i realised my envrionment was in Administrator mode, as soon as i switched that off the table appeared. 

[nleuck_101]

@Lexicaltje

Can you elaborate on this a little more.