Forum Discussion

Shri22's avatar
Shri22
New Member
3 years ago

SQL file to PowerBI

Hello everyone. I am new PowerBI user. I have a SQL dump file in my system. It has huge data of 250MB. Now I want to connect it to power BI desktop and analyze it. I am not looking for SQL server connection. I want to directly connect sql file to powerBI. As I have seen the solutions here, the SQL file has to be wrapped to stored procedures and then put into advance settings in sql server connection. But I am not able to wrap dump sql file to stored procedures. Please help me how to wrap up that huge data and which software to use, what are the ways to connect sql file to Power BI?

Need Help
Tips and Tricks

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Shri22 , if the dump is in DB-specific format then it can be challenging. But it is some text file format, you can try importing it as a text file