Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Schema update through analysis services / PowerBI Premium

Hi

 

I have a SQL query that could is constantly changing his schema (Number of columns and column names), and Power BI service schedule refresh doesn't performe schema updates, i can only perform this update if i download the pbix and refresh it on power BI desktop. This is the standard behaviour according to the documentation bellow:

 

I was wondering if anyone has any ideia if there is a standard method where i could update the schema and refresh the data through XMLA or an analysis services DLL with a powershell script. 

 

According to my testing, when processing the partitions/tables through the diferent proceesing methods (Full, Data, Clear and recalc) i can't update the schema

 

Thanks in advance.

2 REPLIES 2
AntrikshSharma
Super User
Super User

@Anonymous You should use ALM Toolkit for schema changes.

Anonymous
Not applicable

I see, but i want to be able to do in a way that i can schedule the refresh. Don't tink i am able to do it through ALM Toolkit.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.