Refresh Dataset (Databricks Data) new Columns missing

[Anonymous]

Hello together,

we are using a Lakehouse Architecure. The data ist stored in a datalakte. With Datrbicks we are creating the tables (SQL Queries). The Report is build with power bi. 

When I add a column in the query in databricks the new column wont appear after an sheduled refresh in the power bi service.

I have to download the dataset. Refresh it in Power BI Desktop (the column appear) and then republish it to the power bi service.

Does somebody has the same problem or knows a solution?

Greetings 

Alex

[Anonymous]

Good Morning @GilbertQ ,
thanks for your reply. No I do not specify columns in the sql query. Thanks for your advice we never had an issue with additional columns but I will keep that in mind.

Greetings

Alex

[GilbertQ]

Hi @Anonymous 

Are you specifying the column names in your SQL Query or using "Select * from table"?

I would always suggest using selecting the column names from the tables. This ensures that nothing breaks if there is an additional column added.

This also means if a new column is added to the underlying table you would then need to modify the SQL query in PBI Desktop, but this will ensure doing it this way that nothing breaks further down the line that you are unaware of.

[Anonymous · Accepted solution]

Good Morning @GilbertQ ,

I have got an answer in an Microsoft Partner Group. 

"Data model metadata changes need to be initiated by a deployment every time. Either be opening in PBI Desktop and publishing, or by using any other way to publish using XMLA endpoints in Premium."

So we have alway to repusblish.

Greetings

Alex