How can we improve Power BI?

Allow Manual Selection of Gateway for Data Source Refresh

When a user tries to schedule a data set for Excel refresh, the power bi website looks for the gateways set up with the data sources having same Excel paths. Even though it might sound convenient for the users, it creates lots of headache for administration. For example, I had machine crashed and rebuilt and the original gateway lost, or multiple gateways shows the same path in my attempt to recover.

How about we allow the user to specify one gateway specifically and do not match the gateway behind the scene to decide what gateway to show and what not to show. The bottom line is that we need to give administrators concrete steps to trace where it fails. The auto detection of path disallows that tracing.
A truly better way is to allow a dashboard user to refresh Excel data in the backend directly. Database connection does not require a gateway, so why Excel connection has to have one. Please contact me if you need to discuss.

3 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Michelle shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.