Forum Discussion
Issue with data
I'm facing an issue with my report. Everytime that I refresh the report, I got different values, and I don't know why.. I'm importing data from a SQL server and Excel.
No one is editing the values in both datasources.
I'm using the last update.
See first refreshing is doesn't matter. It will show the visuals once all refresh done.
Anyhow try this one . sometime it will help u
right click on table and do refresh
11 Replies
Hi,
Can u confirm me if u getting the dimension for these two chart from same table .
if no pls share ur model structure .
i think the prob in relationship.
I've 2 dimensions with data "Mapa_Margens_SAC" (SQL Server) and "Plano" (Excel). I merged both dimensions in one "QTD vs Plano vs Mg"
I'm only using queries in both charts/data labels from QTD vs Plano vs Mg
I guess, if I open in editing mode and refresh 1st the Plano, 2nd Mapa_Margens_SAC, and then QTD vs Plano vs Mg, the values are showing corretly. Any way to setup the order refresh for dimensions?
In Power BI Desktop we can refresh all at a time .
In Power BI Services we can schedule the report using gateway.
I think your prob is Order of refresh delay.