Forum Discussion
Importing SSAS tabular data, Power BI stuck on evaluating
I sort of did, though I’m not sure if it applies to my original problem here. I ended up having various issues where Power BI Desktop would not import data from an SQL Server source either (using which was my first workaround), even when the datasets in question were very small. Ultimately the issue was that we were running Power BI in a Hyper-V virtual Windows machine, and the solution was to increase the number of virtual cores from one to at least two.
Power BI Desktop requirements are given as "CPU: 1 gigahertz (GHz) 64-bit (x64) processor or better recommended", with no mention of multicore being a requirement. Maybe rufengli or someone else at MS should amend this or look into it? I understand that 64-bit processors in practice may always be at least dual-core, but considering that virtualised environments are not uncommon, it would not hurt to clarify this. Also, it would have been helpful if Power BI could throw some sort of error in such cases, instead of running a query forever.
Hopefully this is helpful.
Hi,
Thanks for reporting the problem. Could you provide more details on the issue? The best way for us to diagnose the issue is to provide screenshot and tracing files for issues like this.
Thanks,
Rufeng
Thank you for replying.
I can't post such things as-is on a public forum due to privacy issues, but here's where it gets stuck when trying to import a single column from a single dimension table:
Upon reexamining the extended events output, I noticed that I was mistaken: there actually are some queries being passed to the Analysis Services database. I'm pasting them below:
select [CUBE_NAME], [BASE_CUBE_NAME], [CUBE_CAPTION] from $system.mdschema_cubes where [CUBE_SOURCE] = 1
select [MEASURE_UNIQUE_NAME], [MEASURE_CAPTION], [DATA_TYPE], [MEASUREGROUP_NAME], [MEASURE_DISPLAY_FOLDER] from $system.mdschema_measures where [CUBE_NAME] = @CubeName and [MEASURE_IS_VISIBLE]
select [KPI_NAME], [KPI_CAPTION], [MEASUREGROUP_NAME], [KPI_DISPLAY_FOLDER], [KPI_GOAL], [KPI_STATUS], [KPI_TREND], [KPI_VALUE] from $system.mdschema_kpis where [CUBE_NAME] = @CubeName
select [DIMENSION_UNIQUE_NAME], [DIMENSION_CAPTION] from $system.mdschema_dimensions where [CUBE_NAME] = @CubeName and [DIMENSION_UNIQUE_NAME] <> '[Measures]'
select [DIMENSION_UNIQUE_NAME], [HIERARCHY_UNIQUE_NAME], [HIERARCHY_CAPTION], [HIERARCHY_DISPLAY_FOLDER], [HIERARCHY_ORIGIN], [HIERARCHY_IS_VISIBLE] from $system.mdschema_hierarchies where [CUBE_NAME] = @CubeName and [DIMENSION_UNIQUE_NAME] <> '[Measures]'
select [DIMENSION_UNIQUE_NAME], [HIERARCHY_UNIQUE_NAME], [LEVEL_UNIQUE_NAME], [LEVEL_NUMBER], [LEVEL_CAPTION] from $system.mdschema_levels where [CUBE_NAME] = @CubeName and [LEVEL_NAME] <> '(All)' and [DIMENSION_UNIQUE_NAME] <> '[Measures]'
select [MEASUREGROUP_NAME], [MEASUREGROUP_CAPTION] from $system.mdschema_measuregroups where [CUBE_NAME] = @CubeName
select [CUBE_NAME], [BASE_CUBE_NAME], [CUBE_CAPTION] from $system.mdschema_cubes where [CUBE_SOURCE] = 1
select [MEASURE_UNIQUE_NAME], [MEASURE_CAPTION], [DATA_TYPE], [MEASUREGROUP_NAME], [MEASURE_DISPLAY_FOLDER] from $system.mdschema_measures where [CUBE_NAME] = @CubeName and [MEASURE_IS_VISIBLE]
select [KPI_NAME], [KPI_CAPTION], [MEASUREGROUP_NAME], [KPI_DISPLAY_FOLDER], [KPI_GOAL], [KPI_STATUS], [KPI_TREND], [KPI_VALUE] from $system.mdschema_kpis where [CUBE_NAME] = @CubeName
select [DIMENSION_UNIQUE_NAME], [DIMENSION_CAPTION] from $system.mdschema_dimensions where [CUBE_NAME] = @CubeName and [DIMENSION_UNIQUE_NAME] <> '[Measures]'
select [DIMENSION_UNIQUE_NAME], [HIERARCHY_UNIQUE_NAME], [HIERARCHY_CAPTION], [HIERARCHY_DISPLAY_FOLDER], [HIERARCHY_ORIGIN], [HIERARCHY_IS_VISIBLE] from $system.mdschema_hierarchies where [CUBE_NAME] = @CubeName and [DIMENSION_UNIQUE_NAME] <> '[Measures]'
select [DIMENSION_UNIQUE_NAME], [HIERARCHY_UNIQUE_NAME], [LEVEL_UNIQUE_NAME], [LEVEL_NUMBER], [LEVEL_CAPTION] from $system.mdschema_levels where [CUBE_NAME] = @CubeName and [LEVEL_NAME] <> '(All)' and [DIMENSION_UNIQUE_NAME] <> '[Measures]'
WITH MEMBER [Measures].[Microsoft.Mashup.Engine.One] AS 1 SELECT { [Measures].[Microsoft.Mashup.Engine.One] }ON 0, SUBSET( [D_mydimension].[mycolumn].[mycolumn].ALLMEMBERS, 0, 4096 ) PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON 1 FROM [Model] CELL PROPERTIES VALUE
Each query is followed by two commands containing
”<Cancel xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"/>”
All of the above takes some 20 seconds, after which nothing seems to happen. Power BI Desktop keeps claiming to load something, and will do so for hours if not interrupted.