Data source Schema changed

[LeslieIT]

Hello Everyone,

I have published a report to Power Bi Service that uses a Microsoft SQL Server as the data source,
We recently updated the Database schema and renamed columns and added new ones

BI Desktop, TheTable has refreshsed to reflect the new schema, so all filters work fine

However, when i Publish the same report to Power Bi Service workspace i get the below error, I have readded and reauthenticated the connection, refreshsed the gatwaye connection but still get the below error when attmepting to filter by a column in the same table that the schemawas changed.
Anyone has any suggestion on what to do to resolve this? 

Highly Appreciated 

[v-saisrao-msft]

Hi @LeslieIT,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-saisrao-msft]

Hi @LeslieIT,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft]

Hi @LeslieIT,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[BhavinVyas3003]

You're likely getting this error because Power BI Service is still referring to the old schema.

In Power BI Desktop, go to Transform Data > Data Source Settings, clear permissions, and reconnect to the SQL Server.

Re-check that all columns, visuals, and filters are working fine after schema changes.

Re-publish the report to the Power BI Service.

In the Power BI Service, open Dataset Settings:

Reconfigure the gateway if needed.

Do a manual refresh once.

[LeslieIT]

Hi @BhavinVyas3003 

Thank you for your reply,

I have done all the above steps, and the issue still persisted, I then decided to recreate the report on a fresh new PBIX. file and republished it, i also reconnected the specific SQL dtaabse connection in the Power BI service and the issues still persists

[v-saisrao-msft]

Hi @LeslieIT,

Thank you for reaching out to the Microsoft Fabric Forum Community.

Please try uninstalling and reinstalling the gateway, then reconfigure it. This should resolve the issue.

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.

[LeslieIT]

HI @v-saisrao-msft 

Thank you for your suggestions, unfortunately this did not work, I found the gateway was oudates ,Iunistalled it and then reinstalled the most up to date gateway, recreated my connections in Power BI service but nothing seems to work for this specific model table

[v-saisrao-msft · Accepted solution]

Hi @LeslieIT,

Please check the power query steps affected the table and look for any removed columns or renamed columns any changed datatypes. 

Troubleshoot refresh scenarios - Power BI | Microsoft Learn

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.