Share via

Multidimensional Project Data Source Wizard Fail SSAS

Green Tree 1 Reputation point
2020-08-24T06:15:44.097+00:00

Hello,

I'm trying to create a data cube in Visual Studio (SSDT) and I'm unable to launch Data Source Wizard. When I select New Data Source, I see the wizard, but when I click Next, the wizard dissapears. Has anyone faced such issue? Could this be related to installation? I used instructions found online how to install multidimensional SSAS instance. Or is it more likely to be some setting or connection issues in Visual Studio?

It's the first week I'm working with SQL Server and its services, maybe I could be missing some obvious steps? Projects of tabular mode work well.

Thank you.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,253 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,816 Reputation points
    2020-08-25T01:47:33.577+00:00

    Hi,
    Which version of SSDT/VS are you using now?

    Normally when we click next on the welcome page of New Datasource Wizard, it should show us "Select how to define the connection" page.
    In your case, I suspect the vs extension is broken or not well installed. I suggest you uninstall the vs analysis service project in vs- extensions. Then reinstall it.
    It should fix the issue.
    Regards,
    Lukas