Update data problem

[alicia57]

Hello everybody!

Several months ago, I have created POWER BI reports. In these reports, data come from queries launched on a SQL Server database.
Today when I try to update these reports to have data from these last months, some columns in my tables are wrong.

When I launch the query directly in the database, results are not the same whereas previous updates in POWER BI were correctly done.

Would you have an idea ?

Thank you very much!

Regards

[v-sihou-msft]

@alicia57

Can you clear cache in Power BI Desktop and refresh the data to see if it shows correct data?

If the issue still persists, please delete the data source and create it. 

Regards,

[alicia57]

Thank you for your reply!

I have cleared cache and the issue still persists. I have tried your second solution but when I click on "Clear permissions", nothing happened. Even if I close and re-open the window, the data sources are always displayed.

But before creating this post, I tried to create the same report again and the problem was the same.

Regards