Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |