Forum Discussion

amansin19's avatar
amansin19
Frequent Visitor
4 years ago
Solved

How to import .bak file into Power BI

I recently went through the adventure bakery dataset  where I downloaded .bak file but I am confused how to load it into PowerBI and apply some analysis on it.   Please let me know regarding it.
Need Help
  • Burningsuit's avatar
    Burningsuit
    4 years ago

    Hi amansin19 

    A .bak file is usually a SQL Database backup file. So I'm guessing that what you have is a backup file of the adventure bakery database, which you need to restore to SQL server to access the data.

    see Restore a Database Backup Using SSMS - SQL Server | Microsoft Docs

    Once you've got the SQL data restored you can connect to it with Power BI to report upon it.

    hope this helps

    Stuart

Burningsuit's avatar
Burningsuit
Icon for Resident Rockstar rankResident Rockstar
4 years ago

Hi amansin19 

A .bak file is usually a SQL Database backup file. So I'm guessing that what you have is a backup file of the adventure bakery database, which you need to restore to SQL server to access the data.

see Restore a Database Backup Using SSMS - SQL Server | Microsoft Docs

Once you've got the SQL data restored you can connect to it with Power BI to report upon it.

hope this helps

Stuart

  • amansin19's avatar
    amansin19
    Frequent Visitor
    4 years ago

    Hi Burningsuit 

    Thanks for your comment, I will try this method as you mentioned.