Data changing when push file to server

[Anonymous]

Hi all,

I have a PBI file that refreshes locally just fine & shows correct data however when I push the file online the data is completely different. how can this be happening/ what can I do?

I tried deleting the file from the server and relaunching it, that worked until the file auto refreshed in the server. 

Thank you!

[v-cazheng-msft]

Hi @Anonymous 

What is your data source? What connection mode you are using, Import or Direct Query or Live Connection?

Are all the data changed or a certain type such as the date type changed?

Best Regards

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[Anonymous]

Data source is SQL and KQL using direct query.

all the data has changed, the numbers look compounded 

[v-cazheng-msft]

Hi @Anonymous 

I think you can try to Clear Data Cache in Options, then republish the report.

If you still have question, please let me known.

Best Regards

CaiyunnZhengg

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[Anonymous]

@v-cazheng-msft  I tried clearing the cache and it didnt work. any other ideas on what could cause the issues? you can reach me on teams also. v-diciglio

[v-cazheng-msft]

Hi @Anonymous 

I'm really sorry, but we can't provide support outside of this post. Can you tell me more details about how you get data from SQL and KQL? Does your organization have users who use the same data source as you and share this data source with you? Are your reports stored in Premium capacity?

Best Regards

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

thank you, I will try this and let you know if it worked