4. When I try to import the table into PowerBI the table does not show:
Any ideas as to why this could be happening?.
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
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?.
@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.
Thanks for your help. So I had a look at it it turns out the table is under 'cr8b5_customers'.
There are loads of strangle column names in there. I'm also not sure where the cr8b5_ prefix came from.
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.
It still doesn't request any URL from me.
@HamidBee , did you clear the permission for the Data Source in current file?
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
|
Hi @AhmedSalih
I just tried what you suggested. I cleared all permissions:
'Get Data' -> 'Dataverse'
I then get a prompt asking me to sign in to my organisational account:
It then takes me straight to the db view. I didn't get any prompt to enter a URL strangely.
Hello, @HamidBee you will need to clear the current permissions and then add data:
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
|
mmbr1606
22
Super User 2025 Season 1
stampcoin
19
Michael E. Gernaey
15
Super User 2025 Season 1