Forum Discussion
Power Query Values not Updating Values when Report is Deployed to Power BI Report Server
Anonymous
I am sorry that I am confused with your post. To clarify something:1. In the first place, are you sure you are using Power BI Report Server not Power BI Service? There 2 different products.
2. Your code is M (power query) not DAX functions(power bi desktop report layer).
3. Refresh in power bi report server is refreshing the new updated datasource data not the new query code in the pbix file, change the query will not make change to the report on report server unless you upload the new pbix to Report Server, this is same as report in Power Bi Service.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Paul Zheng _ Community Support Team
Hi Anonymous ,
Sorry for the confusion - I had updated the title to Power Query but forgot to change the detail within the ticket.
We are using Report Server.
Anonymous wrote:Refresh in power bi report server is refreshing the new updated datasource data not the new query code in the pbix file, change the query will not make change to the report on report server unless you upload the new pbix to Report Server, this is same as report in Power Bi Service.
That confirms what I thought, the Power Query values are not being updated unless the report is refreshed locally and then re-uploaded.
The report was given to me after the report creator left, and I don't want to have to re-upload it every month, so I will research a better way to do it.
Thank you! ๐
I'm not sure about question, but sure Power Query values are updated during Refresh data, no matter if you run refresh in Power BI Desktop or Power BI Report Server or Power BI Service. Only in case when "Include in report refresh" is off, then source is not updated.