Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hello everyone,
I want to build some dashboards and queries for my Company, given that our ERP is not so complete and it lacks of data visualization.
But, as it is the first time I connect PQ with an Access database, I want to make sure that its not going to harm Company data or cause any kind of conflict. The main reason I ask this is because the ERP is connected to the database and employees use it at the same time.
So I just wanted to know if by connecting PQ to Access database I could do any harm to my company data or is it totally safe, or should I know something in advance...??
Thank you very much!
Solved! Go to Solution.
Hi @Syndicate_Admin ,
Making any changes in Query Editor won't affect your origianl data from database.
If you update the source data in database, you should click the refresh button manually so that the dataset loaded to desktop will be updated correspondingly.
Refer to:
Power BI security white paper - Power BI | Microsoft Docs
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Syndicate_Admin ,
Making any changes in Query Editor won't affect your origianl data from database.
If you update the source data in database, you should click the refresh button manually so that the dataset loaded to desktop will be updated correspondingly.
Refer to:
Power BI security white paper - Power BI | Microsoft Docs
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.