Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to Solution.
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
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
Hi @Burningsuit
Thanks for your comment, I will try this method as you mentioned.
User | Count |
---|---|
42 | |
25 | |
22 | |
20 | |
17 |
User | Count |
---|---|
54 | |
43 | |
24 | |
21 | |
20 |