Error when loading adventure works dataset to SSMS

SQL
1

Hello team,

Based on “SQL for DAX Developers” course am trying load Adventure dataset to SSMS but I’m getting error when loading ,Please find the below screenshot…

Can someone please assist me on the same?

image
image865×529 23.5 KB

2

@Dharma Is that a SQL Script? You need to use a BAK file.

3

Yes, Am using the BAK adventure file which is downloaded from Microsoft

4

Hi @Dharma

We noticed that your inquiry was left unsolved for quite some time now.
Looks like your inquiry was out of the experts’ and users’ bounds.

If you were sure you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, your membership also comes with relevant resources that may help you with your Power BI education, so we advise that you check these resources as well.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!