User Accounts and Access queries

Hi darrylwilson,

Basic difference of Power BI with Access is the provision of editing data. Withing Access, you can allow users to edit data using forms or some other mechanism but Power BI is different to that. You can load data from different data sources but when data is loaded, you can't edit it. Yes, you can manipulate data using DAX.

Regarding problem related to loosing previous queries, in Power BI once you have created your queries to load data from different soruces (in your case, it will be access file which is being downloaded), users can use same Power BI report/DAX formulas applied with fresh copy (using Power BI Desktop) untill structure of new downloaded file is same. If you want to use Power BI cloud service, then you need to apply some security mechanism to give users access to proper data and refreshing using gateway.

Users can create their own reports using Power BI Desktop and it will be local. If they use cloud app, then they can use advance features for sharing content with others.

Question related to importing of existing report and quereis form data warehouse to Power BI is very generic. What you want to import and what environment you already have as your reports and datawarehouse?