PowerBI dataset refresh in the server not bringing new columns or delete columns

Question

We have a process which build tables dynamically in the Oracle database. That mean, table may add new columns or delete old columns. We have created PowerBI dataset using "select * from table_a order by 1". Then published this report in the server and set it up to refresh daily. Few days all worked well.

Then few new columns are added in table_a, but daily refresh didn't bring those columns. Now, I downloaded the PBIX from the server, opened in PowerBI Desktop app, refreshed the datasets. All new columns are added to dataset. Saved the file, published again to the server. Looks like a bug in PowerBI server refresh. One more thing, if a column is deleted in the table, refresh in the server fails, same method used to resolve - download, refresh, save and publish.

Is there a way fix this issue? I appreciate any help here.

As of now, I have to download PBIX, open in Desktop app, Refresh dataset, save and publish again. Our plan is do this for every month or until a failure or customer notice about missing new columns.

Sam Nseir · Accepted Answer · 2025-01-25 13:35:39Z

0

When you do a refresh in PBI Desktop, it is also refreshing the data model meta data/schema. Where as in PBI Service, it is only refreshing the data.

You'll need to continue refresh and publish in Desktop, or look at XMLA Enpōint or ALM Toolkit.

answered Jan 25 at 13:35

Sam Nseir

13.1k2 gold badges5 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PowerBI dataset refresh in the server not bringing new columns or delete columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related