Forum Discussion

Garbo62's avatar
Garbo62
Resolver I
2 years ago
Solved

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