Auto update of dashboard

[Anonymous]

Hi,

I'm building a dashboard from couple of tables that have relationship, the tables conatins measures and calculated columns.

My question is - how can i change a measure without update the dashboard (get the message: "working on it..")?

I want the manually refresh the dashboad after couple of changes.

Regards,

Eran

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[Anonymous]

@Anonymous

Are you using Power BI Desktop or Power BI Services?

[Anonymous]

@Anonymous 

Desktop

[Anonymous]

@Anonymous

Okay can you provide an example of an auto update?

If I understand your problem correctly, you can just change the measure or calculated column, unless of course you need to update the data source.

[Anonymous]

@Anonymous

Eveything works fine, but my issue is that each measure update cause the dashboard tiles to update and it takes long time, so i want to change couple of measures and only then update the dashboard manually. 

[Anonymous]

@Anonymous

I understand what you are saying. As far as I know you can't do that. The best work around I can come up with is creating tables that resembles your data and then create all the measures in a new report and then afterwards insert the data.

[Anonymous]

@Anonymous

I'm not quite sure i understand the workaround,

can you give a simple example?

[Anonymous · Accepted solution]

@Anonymous

I'll make an example of the work around for you.

1. Create a new report.

2. Create the table structure that you data has, but do not insert data.

3. Create all the measures you need.

4. Insert the data.

This will ensure that it doesn't have to update every time you make new measures, but it will still take some work for you to go through the 4 steps, especially if you have to do it often.

Another solution could be to create all your measures in a new report with sample data, and then, when done, insert all the correct data into that report. Does it make sense?

[Anonymous]

@Anonymous

Yes, i understand.

Thanks, i'll check this out.