Autoupdate when moving columns

[whatever61]

First of all, wow.. the amount of relogins I have to do to make a simple action and the amount of effort to find some very basic functions like auto-refresh (why would someone use a dashboard that doesn't have a fresh data?!?) or to find the price of the premium version is ridicilous. Very disappointed that Microsoft cannot hire a UI specialist.

The second problem I am constantly having is that my dataset in excel is moving sometimes (changing columns). That ruins the dataset that it gets into the Power BI.

Is it not possible to take a dataset based on column headers or from a NameManager?

Thanks

[whatever61]

I found it myself.

Thanks

[Anonymous]

Hi @whatever61,

Can you please share your solution here? I think it will be help of someone who faced the similar requirement.

For auto refresh dashboard, you can take a look at scheduled refresh:

Configuring scheduled refresh

Regards,

Xiaoxin Sheng

[whatever61 · Accepted solution]

When using GET DATA you can actually choose tables also.

So first you make a range as a table and then you connect to that table instead of to a sheet.