Forum Discussion

pantmeha's avatar
pantmeha
New Member
7 years ago
Solved

New fields from Bex Query not seen in Power BI

Hello Team,   I have created a Power BI Report based on BEX Query using Import option. Now I have added a new field to Bex query but this field is not visible in Edit queries of Power BI. How do I ...
Need Help
  • ErnoNykanen's avatar
    ErnoNykanen
    5 years ago

    I had a similar issue:

    1. Initially I had existing PowerQuery using existing BEx query
    2. Added new field to BEx query
    3. Not able to see new field in PowerQuery when trying to add the new field in "Added Items" step.

    I solved this by refreshing the preview data in the query. Seems that this is then also refreshing the data source table. It's very unintuitive that using the "Added items" feature the PowerQuery is actually reading the preview data from the previous "Navigation" step but that would seem to explain it as even manually adding the new field via advanced editor didn't work.

ErnoNykanen's avatar
ErnoNykanen
Frequent Visitor
5 years ago

I had a similar issue:

  1. Initially I had existing PowerQuery using existing BEx query
  2. Added new field to BEx query
  3. Not able to see new field in PowerQuery when trying to add the new field in "Added Items" step.

I solved this by refreshing the preview data in the query. Seems that this is then also refreshing the data source table. It's very unintuitive that using the "Added items" feature the PowerQuery is actually reading the preview data from the previous "Navigation" step but that would seem to explain it as even manually adding the new field via advanced editor didn't work.