Forum Discussion
Continued ContributorIssues with the new export with live connection
There's a new option when you export Summarized Data which says ".xlsx (Excel) with live connection (500,000 row max)
I have 2 problems:
1. We don't want users creating output with live connections most of the time. How do I turn off this option?
2. At least half of the time I get an error when I try to do this
it either works for a visual or it doesn't. I've tried this with a number bar charts and tables
Is there anything that I can do to fix the error?
Is there any way to turn off the "live connection" option? I don't see any in the report settings in the desktop
I've been in contact with microsoft support. Here is what they told me:
1. The reason some visuals cannot be exported with the new option is that the visual includes a meaure that exists only in the dashboard instead of the datasource. So if the export succeeded it woudn't work because that measure wouldn't be available in the live connection to the datasource. If you plan on using this option make sure that all your measures are in the datasource instead of the dashboard.
2. If I turn off building on the datasource in the service for that datasource (commonly used in analyze in excel), this new option will not appear for export since the user will not be able to connect to the datasource later. This can be done individually for each datasource instead of a global tenant setting, but it will affect every dashboard that uses that datasource.
Since we have over 50 dashboards that use this datasource and also have users that connect to the datasource through excel, we are stuck with a big job of migration of measures to the datasource. Any future dashboards with new measures will be added to the datasource so the export will work on those dashboards.
I've submitted a request to PBI that an control be added to the report settings to allow the developer to select the export options much like the existing export level of detail options. This will allow me to control this on a dashboard by dashboard basis.
8 Replies
bshefferI've been in contact with microsoft support. Here is what they told me:
1. The reason some visuals cannot be exported with the new option is that the visual includes a meaure that exists only in the dashboard instead of the datasource. So if the export succeeded it woudn't work because that measure wouldn't be available in the live connection to the datasource. If you plan on using this option make sure that all your measures are in the datasource instead of the dashboard.
2. If I turn off building on the datasource in the service for that datasource (commonly used in analyze in excel), this new option will not appear for export since the user will not be able to connect to the datasource later. This can be done individually for each datasource instead of a global tenant setting, but it will affect every dashboard that uses that datasource.
Since we have over 50 dashboards that use this datasource and also have users that connect to the datasource through excel, we are stuck with a big job of migration of measures to the datasource. Any future dashboards with new measures will be added to the datasource so the export will work on those dashboards.
I've submitted a request to PBI that an control be added to the report settings to allow the developer to select the export options much like the existing export level of detail options. This will allow me to control this on a dashboard by dashboard basis.
- lbendlin
Super User
We don't want users creating output with live connections most of the time.Can you please elaborate why?
- bsheffer
we refresh on a schedule. A live connection implies that the data is always up to date. This confuses the users.
if we wanted to do that, we would use analyze in excel
- lbendlin
Fair point. Similar to the discussion of "dataset refreshed" vs "source data refreshed".
You could include a disclaimer in your report UI. You can raise an issue at https://issues.powerbi.com . If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/
Same issue here also
We don't want users creating output with live connections most of the time. How do I turn off this option?
- lbendlin
It's not a live connection (despite what the name says). It's a verbatim copy of the DAX query that feeds the visual. So this is no different than running DAX queries against the data set. If you don't want that then take away the Build permissions from your users.
