Forum Discussion

cwarnholtz's avatar
cwarnholtz
New Member
2 years ago

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

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 disappe...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
cwarnholtz
New Member
2 years ago

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