Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Query Values not Updating Values when Report is Deployed to Power BI Report Server

Hi all,   (Last post got deleted automatically when I changed the title!)   I have read a lot of posts around this but couldn't come to an exact conclusion so thought I would post, apologies if I...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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! 🙂 

     

     

     

     

    • josef78's avatar
      josef78
      Memorable Member
      5 years ago

      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.