Forum Discussion
Doubt with Power query – database conection
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!
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.
1 Reply
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.