Forum Discussion

smalltownbear's avatar
smalltownbear
Frequent Visitor
1 year ago
Solved

New Columns in Dataflow not Displaying in Semantic Model

I have a dataflow in the PBI service that consists of a single SQL query executed against an on-prem SQL Server database. There are no transformations on the result of the query.   I also have a se...
Dataflow
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi smalltownbear , GilbertQ, thank you for your prompt reply!

     

    Quote from Microsoft:

     

    Changes in data source table structure, or schema, such as a new, renamed, or removed column can only be applied in Power BI Desktop, and in the Power BI service they can cause the refresh to fail.

     

    Best regards,

    Joyce

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

     



Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi smalltownbear , GilbertQ, thank you for your prompt reply!

 

Quote from Microsoft:

 

Changes in data source table structure, or schema, such as a new, renamed, or removed column can only be applied in Power BI Desktop, and in the Power BI service they can cause the refresh to fail.

 

Best regards,

Joyce

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