Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

Power BI Dashboard Gateway Refresh - Failure after addition of New Column

Hi All,

         I have a Power BI dashboard that uses Gateway to refresh from the Database.

It was working well until recently we added a new column to the source views. After that the refresh through the gateway is failing. I checked individually and the refresh fails for the views where the column is newly added.

 

Also 2 views have the column added and both have the same error. 

 

Below is the error mail that i got after failure:

Error.png

 

I suspect any of the below issues - 1. The new column has space 'Column A' unlike the other columns in the view which are separated by underscore.

2.There is a name difference between the Dev DB i have access to and the Prod DB i refresh using the Gateway.

 

Kindly help how to resolve this issue.

1 ACCEPTED SOLUTION
avatar user
Anonymous
Not applicable

Syndicated - Outbound

Error happened since the Prod DB & Dev DB columns were named differently and hence it was not being identified from the Gateway.

View solution in original post

3 REPLIES 3
TheoC
Super User
Super User

Syndicated - Outbound

Hi @Anonymous 

 

Can you try perform the refresh in Power BI Desktop manually and see if there is an error in the load?  The error may stem from the additional column not being incorporated into the PBIX and you may need to republish the Power BI file to the respective workspace in Power BI Service.

 

Let me know how it works out either way! 🙂

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

avatar user
Anonymous
Not applicable

Syndicated - Outbound

Error happened since the Prod DB & Dev DB columns were named differently and hence it was not being identified from the Gateway.

Syndicated - Outbound

@Anonymous, are you able to provide some detail on the steps you took to resolve the issue? By adding the steps, it will help others who are experiencing the same challenge look at your post and re-perform the steps you applied to resolve.

 

Glad you found and resolved the issue! 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)