problem with publishing

[Anonymous]

Hi everyone!

I have a problem with publishing of my report. I have an Excel file with information about validation of contracts. I've made a report in Desktop and it works correct, for example it shows that some contract has been on validation during 55 days, it's correct information. But when I publish it in Service and refresh, all info, visualisations and numbers change, for example that very contract has been on validation -13 days, it's not correct. And there's no mistake message where I could click to see information about mistake.

I well be very gratiful for your help!!

[v-juanli-msft]

Hi @Anonymous 

To reproduce your problem and find a solution, please show me more details:

1.do you configure a gateway and add excel file on premise as a data source under the gateway?

2.where is the wrong data?

does it lie in a measure or a column which you created with Power BI Desktop or in a original column?

could you show an screenshot to clear me?

a screenshot from Power BI Desktop and another from Power BI Service are prefered.

3.if you add columns in a table visual, do you check if this column is aggregated?

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Maggie,@v-juanli-msft 

1. Excel file is my source for pbi desktop, I use my coworker's gateway to refresh it in servise, if I answered to your question?

2. I have a problem to add screenshot, when I press "Insert/edit image", it asks to fill Source and image discription, what should I do? And copy/past doesn't work here 😞

3. I use measures to count and summ, I use DAX. If I understood your question correct

Thank you,

BR

Daria

[v-juanli-msft]

Hi @Anonymous 

To insert pictures, you need to sign in Power BI Forums with your Power BI account, then you could see "insert picture" icon as mine.

Or you could upload your picture in OneDrive or any other cloud space and share the link here for me to get.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

I have seen this happen more recently and what it appears to me is that it is often an error on an underlying column when the data is being refreshed.

Or there is a Persistent filter, or other filters added on the report page which is affecting the results.