Power BI Desktop Additional Column

[Anonymous]

Dear Team,

I am using Power BI Desktop (Feb 2018) version. In my application, we are using Direct Query mode and connected to Azure SQL database. 

In database, we have added few columns in the table and we were expecting that after dataset refresh in Power BI Service, these new columns should be populated for end users, but didn't get new columns, we had to refresh the application at desktop and then republish. 

Is this the expected behaviour or I am missing something to populate the columns automatically in Power BI Service.

[Anonymous · Accepted solution]

Hi @Anonymous,

>>In database, we have added few columns in the table and we were expecting that after dataset refresh in Power BI Service, these new columns should be populated for end users, but didn't get new columns, we had to refresh the application at desktop and then republish. 

Current power query will cache original datasource structure in query steps, they not follow changes on database. If cached table structure not correspond new table structure(missing columns), it will return error.  If datasource added new columns, power query still load previous structure.(new columns not load)

For your scenario, you need to manually add new columns list to change type steps.

 

Regards,

Xiaoxin Sheng