After parameterizing the Dataverse connection database the Report View loses the column labels

[cwarnholtz]

A nice feature of the Dataverse connector is that it brings in all the user friendly column labels to the Report View.

If I change the source to use a parameter the friendly column labels disappear.

Source = CommonDataService.Database("uatenvironment.crm.dynamics.com",[])  --> this brings in column labels

Source = CommonDataService.Database(DataverseSource,[])  --> this DOES NOT bring in column labels

Is there a way to parameterize the connection and have friendly labels?

Thanks,

Craig

[Anonymous]

Hi @cwarnholtz ,

Based on the problems, here are my answers.

Firstly when after parameterizing your connection, you might need to explicitly define or map your metadata to ensure that the friendly column labels are preserved. 

Then you can read the Dataverse document: Power BI modeling guidance for Power Platform - Power BI | Microsoft Learn

I think this document may help you learn more about parameterization in data connections and how it might affect metadata: Parameterize linked services - Azure Data Factory & Azure Synapse | Microsoft Learn

Finally Ensure that your Dataverse connector configuration in Dataflow Gen2 or any other service you're using is correctly set up.: OneLake shortcuts - Microsoft Fabric | Microsoft Learn

Best Regards

Yilong Zhou

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

[cwarnholtz]

Hi Yilong,

I'm not having trouble with using the Dataverse connection or parameterizing. I'm questioning why I am losing the column label retrieval feature simply because I parameterized. Not a very useful feature in the real world.

Would you have an efficient solution to explicitly mapping the column labels?

Thanks,

Craig