Forum Discussion
meiyl
10 years agoMicrosoft Employee
Date Refresh Timeout issue
Dataset exceeds the time out in either Refresh Schedule or Refresh Now(By the way the shedule history marked it as completed after another refresh start). Any suggestions for the timeout issues? Use...
ianbarker
10 years agoHelper III
You probably are better using the Enterprise Gateway but I think this won't help with your performance issue.
It might be worth creating a view in SQL and then just connecting to that view rather than using the advanced editor.
Also, another consideration is if you have done additional modeling using the Query Editor. If you have added additional steps here, this could be cuasing performance issues.
meiyl
10 years agoMicrosoft Employee
Yeah. We want replace a lot of colunm name to another name and filter some colunm in PowerBI, we don't want it change in the SQL Sever (because some other powerbi use the same data), other than write it in advanced editor, any other ways to do this?