Forum Discussion
Helper IIAdventure Works DW 2020 (v1) Connection Issues
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.
Here - 4 years after this post, as I look to brush up on some Power BI skills, I wrestle with the same (non) issue.
In multiple attempts to get past the error which included numerous internet searches and even installing SQLExpress locally and restoring Adventure Works DW 2020, I did finally find this explanation.
Would be nice if the "curators" at Microsoft Learn would state something to this effect - Don't waste your time refreshing the data - it is already cached in the PBIX file you downloaded! when suggesting to download the PBIX's used in the training material.
Hi DHBallantyne When I open my .pbix file, there is this error message saying "Some of the tables have incomplete or no data". It doesn't refresh when I click the Refresh Now button. Did you fix it by installing SQLExpress locally and restoring Adventure Works DW 2020?
