AS Tabular and Sample Data in VS

• philipp

  SSC Rookie

  Points: 32

  More actions

  May 25, 2020 at 1:02 pm

  #3757214

  Hello all,

  I really need your help – I want to use the sample data in an Analysis Services Project in the Visual Studio, but the sample Data from the Sample Partitions will not be displayed.

  The actual situation:

  I use a Tabular AS Server 2016 and 2019

  Visual Studio 2019 with the latest Data Tools

  The data source is SQL Server (2014 / 2019), I’ve tried also the Legacy Mode of the data source

  The impersonation mode was created with a AD account which has access to the data

  I don’t use the Import Mode, I use Direct Query

  I connected two tables, one fact (5 bn rows, one dimension) and created sample partitionsAfter a “Refresh All” the VS reads all the data (the dialogue shows the process) and after finishing the visual studio shows no data in the grid.

  When I start Excel with Sample Data from the Visual Studio I can work with the data

  I’ve tried it also with a Visual Studio 2015 on a other Machine – but also with no success.

   

  Hope anyone has a hint for me …

   

  Best

  Philipp

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  May 26, 2020 at 1:10 pm

  #3757404

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.