Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Answered

Dataverse Table not appearing in Power BI

(0) ShareShare
ReportReport
Posted on by 930 Super User 2024 Season 1
  1. I created an Environment in Power Apps.
  2. I then created a table by importing data from a SharePoint List.

HamidBee_0-1665493395086.png

      4. When I try to import the table into PowerBI the table does not show:

HamidBee_1-1665493514664.png

Any ideas as to why this could be happening?.

 

Categories:
  • CU25061832-1 Profile Picture
    on at
    Re: Dataverse Table not appearing in Power BI

    I just installed my powerbi desktop, did a first time login and could not see my tabes, reading comment from @AhmedSalih , made no sense ,, but anyways i tried and that helped 

  • HamidBee Profile Picture
    930 Super User 2024 Season 1 on at
    Re: Table not appearing in Power BI

    Hi @AhmedSalih thanks for the explanation. Just to clarify, there is no way of removing the prefix?. Also, is there a way to prevent Dataverse from creating system columns?.

  • AhmedSalih Profile Picture
    6,678 Super User 2025 Season 1 on at
    Re: Table not appearing in Power BI

    @HamidBee, if you create the tables outside a solution, the system will create a prefix for you. If you create them inside a solution, they will have the prefix of the solution that you create when you create the solution. 

     

    For the columns, Dataverse create system columns for you by default. 

     

     

  • HamidBee Profile Picture
    930 Super User 2024 Season 1 on at
    Re: Table not appearing in Power BI

    Thanks for your help. So I had a look at it it turns out the table is under 'cr8b5_customers'.

     

    HamidBee_0-1665504951027.png

     

    There are loads of strangle column names in there. I'm also not sure where the cr8b5_ prefix came from. 

     

  • AhmedSalih Profile Picture
    6,678 Super User 2025 Season 1 on at
    Re: Table not appearing in Power BI

    @HamidBee, have you tried to access this one?:

    AhmedSalih_0-1665503616803.png

     

  • HamidBee Profile Picture
    930 Super User 2024 Season 1 on at
    Re: Table not appearing in Power BI

    Hi @AhmedSalih 

     

    I cleared all permissions for current file and global permissions. I then tried to import data from Dataverse. It repeats the same thing. It asks me to sign in with my organizational account and choose the table. 

     

    HamidBee_0-1665503343632.png

     

    It still doesn't request any URL from me. 

     

  • AhmedSalih Profile Picture
    6,678 Super User 2025 Season 1 on at
    Re: Table not appearing in Power BI

    @HamidBee , did you clear the permission for the Data Source in current file?

    AhmedSalih_0-1665502937854.png

     

     

     

    If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


    I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


    Visit my Blog: www.powerplatformplace.com


     

     

  • HamidBee Profile Picture
    930 Super User 2024 Season 1 on at
    Re: Table not appearing in Power BI

    Hi @AhmedSalih

     

    I just tried what you suggested. I cleared all permissions:

     

    HamidBee_0-1665502671964.png

    'Get Data' -> 'Dataverse'

     

    I then get a prompt asking me to sign in to my organisational account:

     

    HamidBee_1-1665502746231.png

    It then takes me straight to the db view. I didn't get any prompt to enter a URL strangely.

     

    HamidBee_2-1665502819312.png

     

     

     

  • AhmedSalih Profile Picture
    6,678 Super User 2025 Season 1 on at
    Re: Table not appearing in Power BI

    @HamidBee, to get the URL, click in the Gear icon and then click session details > Instance Url

    AhmedSalih_1-1665502459247.png

     

  • Verified answer
    AhmedSalih Profile Picture
    6,678 Super User 2025 Season 1 on at
    Re: Table not appearing in Power BI

    Hello, @HamidBee you will need to clear the current permissions and then add data:

    AhmedSalih_0-1665502136308.png

     

    1111.png

     

    After clearing all permissions, you will be prompt to enter the instance url again, so make sure you enter the correct one.

     

     

    If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


    I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


    Visit my Blog: www.powerplatformplace.com


     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 19

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 15 Super User 2025 Season 1

Overall leaderboard

Featured topics