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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
smjzahid
Helper V
Helper V

Column from dataflow not showing values using the CDS connector

Hi,

 

I have a dataflow with 2 entities inside it and for one of the entities named staging_DEV_RMS (Load Disabled), this is based on below query

 

image.png

 The second entity named Risk Register is referencing above entity and removes and renames few columns. 

 

The query for Risk Register (Load Enabled) is shown below

 

 

let
  Source = staging_DEV_RMS,
  #"Removed columns" = Table.RemoveColumns(Source, {"createdby", "createdonbehalfby", "exchangerate", "importsequencenumber", "modifiedby", "modifiedon", "modifiedonbehalfby", "overriddencreatedon", "ownerid", "owningbusinessunit", "owningteam", "owninguser", "processid", "stageid", "statecode", "statecode_display", "statuscode", "statuscode_display", "timezoneruleversionnumber", "transactioncurrencyid", "traversedpath", "utcconversiontimezonecode", "versionnumber", "crf7a_currentassessedexposure_base", "crf7a_currentmaximumexposure_base", "crf7a_currentminimumexposure_base", "crf7a_currentexposurecost_base", "crf7a_currentexposurecost2_base", "crf7a_maximumcost_base", "crf7a_minimumcost_base", "crf7a_mostlikelycost_base", "crf7a_organisationbreakdownstructure", "crf7a_postactionplanexposurecost_base", "crf7a_workstream", "crf7a_section", "crf7a_pmbexposure_base", "crf7a_postactionplanexposurecost_state", "crf7a_reporting", "crf7a_issue", "crf7a_postactionplanexposurecost_date", "crf7a_riskbreakdownstructure", "crf7a_risklevel", "crf7a_section4exposure", "crf7a_section4exposure_base", "crf7a_section_display", "crf7a_typeexposurevalue_base"}),
  #"Renamed columns" = Table.RenameColumns(#"Removed columns", {{"crf7a_cause", "Cause"}, {"crf7a_armid", "ARM id"}, {"crf7a_approvaltype", "Approval Type"}, {"crf7a_approvaldate", "Approval Date"}, {"crf7a_closeddate", "Closed Date"}, {"crf7a_comments", "Comments"}, {"crf7a_covid19impact", "COVID Impact"}, {"crf7a_criticalpathdaysimpact", "Critical Path Day Delay"}, {"crf7a_currentassessedexposure", "Current Assessed Exposure"}, {"crf7a_currentexposurecost", "Current Exposure Cost"}, {"crf7a_currentexposurecost2", "Current Exposure Cost2"}, {"crf7a_currentmaximumexposure", "Current Maximum Exposure"}, {"crf7a_currentminimumexposure", "Current Minimum Exposure"}, {"crf7a_currentprobability", "Current Probability"}, {"crf7a_effect", "Effect"}, {"crf7a_fishbone_display", "Fishbone Code"}, {"crf7a_float", "Float"}, {"crf7a_issue_display", "Issue"}, {"crf7a_maximumcost", "Maximum Cost"}, {"crf7a_maximumtime", "Maximum Time"}, {"crf7a_minimumcost", "Minimum Cost"}, {"crf7a_minimumtime", "Minimum Time"}, {"crf7a_mitigationsummary", "Mitigation Summary"}, {"crf7a_mostlikelycost", "Most Likely Cost"}, {"crf7a_mostlikelytime", "Most Likely Time"}, {"crf7a_organisationbreakdownstructure_display", "OBS"}, {"crf7a_pmbexposure", "PMB Exposure"}, {"crf7a_postactionplanexposurecost", "Post Action Plan Exposure Cost"}, {"crf7a_premitcritical", "Pre Mitigation Critical"}, {"crf7a_premitmaxtime", "Pre Mitigation Max Time"}, {"crf7a_premitmintime", "Pre Mitigation Min Time"}, {"crf7a_premitmosttime", "Pre Mitigation Most Likley Time"}, {"crf7a_probabilitypercentage", "Baseline Probability"}, {"crf7a_reporting_display", "Reporting Area"}, {"crf7a_retirementdate", "Retirement Date"}, {"crf7a_risk", "Risk"}, {"crf7a_riskid", "Risk ID"}, {"crf7a_risklevel_display", "Risk Level"}, {"crf7a_risktitle", "Risk Title"}, {"crf7a_risktype_display", "Risk Type"}, {"crf7a_status_display", "Risk Status"}, {"crf7a_triggerdate", "Trigger Date"}, {"crf7a_typeexposurevalue", "Baseline Exposure Cost"}, {"crf7a_workstream_display", "Workstream"}, {"crf7a_discipline_display", "Discipline"}, {"crf7a_riskbreakdownstructure_display", "Risk Breakdown Structure"}})
in
  #"Renamed columns"

 

 

When I connect to this dataflow from within PBI desktop, I dont see the values in column named (RBS) from within PBI desktop. It has all null values inside it.  However, when I open the dataflow (Power Query Online) from the PBI Service I can see the (RBS column) with all the values populated , shown below 

 

image.png

 

I have tried  below tweaks so far with no joy.

 

Note, WE DO NOT have POWER BI PREMIUM neither PPU in our organisation, only shared capacity with PRO License for users

 

1 Enabled Load for staging_DEV_RMS (bt when I do this it throws below message) saying computed entities are Premium only feature please move this workspace to Premium capacity

 

2 Refreshed the dataflow and saved and closed from the PBI service, started PBI desktop again using the Power BI dataflows connector, connecting to the Risk Register (which has its LOAD ENABLED) in PBI Service) but no luck, the column appears blank without any values.

 

image.png

 

1 REPLY 1
v-yingjl
Community Support
Community Support

Hi @smjzahid ,

Sorry for replying late. 

For Question 1:

Please try to use Duplicate Instead of Reference if you want to enable the Computed Entity. Refer this article which introduces it in details: Workaround for Computed Entity in Power BI Pro: Dataflow in Power BI 

dataflow.png

 

For Question 2:

After Question 1, please refresh the DataFlow on service to make data loaded into the entity. Then, click the "Refresh" button in "Navigator" pane. If still no data is shown, please clear permissions under "Data Source settings", and establish the connection to dataflow again.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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