Forum Discussion

JohnThomas's avatar
JohnThomas
Icon for Helper II rankHelper II
6 years ago
Solved

Adventure Works DW 2020 (v1) Connection Issues

Hi everyone... I have downloaded the Adventure Works DW 2020 (v1) Power BI desktop sample model to use for testing DAX / Power Query from this location: https://aka.ms/dax-docs-samples   When I ...
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    JohnThomas - First, you shouldn't have to refresh the data, it looks like all of the data from the AdventureWorks database is already imported into the model. Second, if you did want to refresh the data, you would need a SQL Server with the AdventureWorks database loaded up locally. The current value of the SQL Server is called POWERBI-SQL although you could change this in the Power Query Editor.

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
6 years ago
ok when you say you have downloaded, this have you loaded this data into sql database? can you connect to the database succesfully in sql?
JohnThomas's avatar
JohnThomas
Icon for Helper II rankHelper II
6 years ago

@vanessafvg - I downloaded the pbix file that's connected to the POWERBI-SQL database on ms server (I assume).  Greg_Deckler provided the solution... which was just don't refresh the data... (This begs the question however, if I am testing something that calls for a refresh such as PQ solution or something then the Adventure Works DW 2020 (v1).pbix doesn't help much unless you can install the db locally, as you suggested...)

 

Thanks for the quick response.