Forum Discussion
Autoupdate when moving columns
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
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.
3 Replies
I found it myself.
Thanks
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:Regards,
Xiaoxin Sheng
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.
