Jukka Niiranen’s Post

View profile for Jukka Niiranen

The Original Power Platform Advisor. 11x Microsoft MVP. Low-code 4 life.

Why are the choice fields from Dataverse for Teams tables showing up as blank in my #PowerBI report? When building the data model from with #MicrosofTeams and using the #PowerApps maker tools there, you won't see a "publish customizations" button. Well, it turns out that even in the new Teams world you DO need to publish your customizations. Since none of my choice fields were returning the display name, only ID values, I had already manually built conditional columns with Power Query to get the reports to show the human readable data I needed. Then I read the awesome new docs by Scott Sewell: "Power BI modeling guidance for Power Platform". "If you discover that Dataverse choice labels are blank in Power BI, it could be because the labels haven't been published to the Tabular Data Stream (TDS) endpoint." Doh! If I had been building this in classic Dataverse, I would have published my solution changes many times by now. Yet with Dataverse for Teams there isn't a solution concept visible in the UI. We need to jump through a hoop and get to the Common Data Service Default Solution in a restricted version of the Maker portal. THEN we can publish our customizations and get the TDS endpoint to return also choice column labels.

  • No alternative text description for this image
Jukka Niiranen

The Original Power Platform Advisor. 11x Microsoft MVP. Low-code 4 life.

1y

For more tips on how to survive with solutions in the land of Dataverse for Teams, see my blog post: https://ff.tips/DV4Tsol

Jukka Niiranen

The Original Power Platform Advisor. 11x Microsoft MVP. Low-code 4 life.

1y

Read the new Power BI + Power Platform guidance documentation from Doc... sorry, I meant Learn: https://learn.microsoft.com/en-us/power-bi/guidance/powerbi-modeling-guidance-for-power-platform

Scott Sewell

Principal Program Manager @ Microsoft | Focused on Microsoft Fabric, Power BI, and Dynamics 365

1y

Glad that was helpful, Jukka Niiranen!

Himanshu Sharmah

Solution Architect / Automation Enthusiast / D365 & Power Platform

1y

This is indeed helpful. Thanks

Vishy Grandhi

Entrepreneur, Dynamics 365

1y

Very insightful Jukka! Thanks for sharing.

See more comments

To view or add a comment, sign in

Explore topics