Forum Discussion
Imported Excel table was not left as a local query
- 7 years ago
Hi walkra
your scenario: you connect to an excel file on local computer, but the uses comsume your report in another computer,
SteveCampbell's suggestion maybe a workaround for your scenario, in addition,
1.
If the users need to modify reports based on your data, (he has the permission to the original data),
Please share the excel file to the user, the user just need to replace the file path with his.
open Edit queries_>Advanced editor, replace the excel file path.
2.
If the users have no permission to the original data, they are just viewers, your report needs to update data when new data is added in data source.
please publish your report from Power BI Desktop to Service,
then download and install the on-premise gateway, configure schedule refresh for the dataset,
then share the reports to users.
https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem
https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
in the query editor, right click the query, and untick "Include in report refresh" - (or Incluir en la actualización del informe, from google translate :smileylol:)
This will stop it updating from the excel file
- walkra7 years ago
Helper III
Hi Steve. How Are You?.
The query was already in that configuration.
I also distilled "Enable Load" where a warning came up.
But now two more queries that work badly.
Thank you very much