Data connection export from SQL Server or direct conection by power query?

Question

Data connection export from SQL Server or direct conection by power query?

Christian Arndt 0

Hello everyone,

I am a BI Analyst and have created Excel based dashboards in my new company. These are connected directly to the SQL database via PowerQuery.

However, our IT department believes that Windows authentication is too insecure and insists that I export to a CSV file via SQL and then access this file. However, this means that the CSV file is freely available in the network, which I have a problem with. What is the most secure data access from the dashboards to a SQL database? I think per direct user on the database with read rights. Many thanks for help
nice greetings
Christian

Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
LiHongMSFT-4306 31,566 Reputation points

2023-03-10T08:39:02.0266667+00:00

Hi @Christian Arndt

We haven't heard any response from you yet.

Do you have further question on this issue, could we offer more support?

If this answer helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

1 answer

Your answer

Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
LiHongMSFT-4306 31,566 Reputation points

2023-03-10T08:39:02.0266667+00:00

Hi @Christian Arndt

We haven't heard any response from you yet.

Do you have further question on this issue, could we offer more support?

If this answer helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

Answer 1

Hi @Christian Arndt

To export or read data from the source database or file, then SELECT permissions on the source tables and views are needed.

Refer to this article for more details: Import and Export Data with the SQL Server Import and Export Wizard.

Also, here is an article showing How to Export Data From Microsoft SQL Server to a CSV File.

Best regards,

Cosmog Hong

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

Data connection export from SQL Server or direct conection by power query?

1 answer

Your answer