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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
DenissonWenergy
New Member

Problem with alter column MySQL in semantic model (On Premises Gateway)

I have a semantic model that is populated, through MySQL, using On-premises gateway.

I added a column to a table in MySQL, but it does not appear in PowerBI Online.

Has anyone experienced the same problem?

2 REPLIES 2
v-heq-msft
Community Support
Community Support

Hi @DenissonWenergy ,
According to your description, when you add a column in MySQL it doesn't show the column you added on the power bi service. You can do the following steps to confirm if the problem still occurs:
1. Ensure that the local data gateway is running properly and the version is up to date.
2. In the Power BI service, trigger a manual refresh. This action prompts Power BI to query the MySQL database through the gateway again. If the gateway and connection are configured correctly, the new columns in the dataset should be included. When you add a new column to the data source you need to refresh the dataset through the gateway to get the latest data.
You can refer to this document to check your gateway settings:
On-premises data gateway in-depth - Power BI | Microsoft Learn

 

Best regards,

Albert He

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

lbendlin
Super User
Super User

That would be a question for your Power Query. Check for a Table.SelectColumns step.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.