How to copy data from Power BI dataset to SSMS database Engine

Question

Dear All,

I wonder how I can copy data from PBI dataset to Database Engine (SSMS)?

I could connect to PBI dataset and I can see table content (with Evaluate) but I need to create an automation or a view in a database engine which drags the data from PBI dataset.

Can you please help me?

Thanks in advance

Peter

Answer 1

Hi @Lancz, Peter (Nokia - HU/Budapest)，

What do you mean of creating an automation or a view?

Could you give a sample for us? Do you mean the view in sql server?

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

but I need to create an automation or a view in a database engine which drags the data from PBI dataset.

SSMS is just a management tool for MS SQL Server.

A relational database stored data in tables = 2-dimensional, while PowerBI is OLAP = n-dimensional; something very different, you can not copy data 1:1 between.