Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Garbo62
Helper II
Helper II

Linking Power BI to Dataverse - Incorrect Column Names

Hi I been trying to connect a Dataverse data set to power BI, but every time the column name are incorrect Half of the columns are prefixed with the database reference, in this case "cr113_" and some are duplicated and some columns have a completely different ending to to the Dataverse, i.e. suffixed with "name" and when prefixed with cr113_ are always in lowercase I.e. I have 2 columns AAsetInvalid and cr113_assetinvalid in the table in PowerBI but it the same column in the Dataverse (Front and backend name) I have about 15 tables to connect and all have issues, can doe some reason I can add any screen shots Is there a know issue connecting Dataverse to Power BI, I'm using desktop
1 REPLY 1
foodd
Super User
Super User

Hello @Garbo62 , and thank you for sharing a question with the Community.  This reply is informational. Please follow the decorum of the Community Forum when asking a question.

Please share your work-in-progress Power BI Desktop file (with sensitive information removed) and any source files in Excel format that fully address your issue or question in a usable format (not as a screenshot). You can upload these files to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then provide the file's URL.

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

 

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors