UPDATE: I think I've figured out why the new column I created isn't showing in PowerBI...as I stated below I cannot see the columns when viewing the table in Microsoft SQL Server Management Studio, and when I right-click on the table the only option I have is for "partitions...", so I clicked on that and thought I was creating a new table column, but apparently it was only creating the new column in a partition. As I mentioned I have no experience with Analysis Services, so I guess the next step is to figure out how to create a table column. Below is the script that gets created for this table, and you can see there's no new column named "Big Sexy", that only shows up in the partition...
{
"create": {
"parentObject": {
"database": "CurrAttendanceAnaysis"
},
"table": {
"name": "Student",
"columns": [
{
"name": "DW_PersonID",
"dataType": "int64",
"isHidden": true,
"isKey": true,
"sourceColumn": "DW_PersonID",
"keepUniqueRows": true,
"summarizeBy": "none"
},
{
"name": "Gender",
"dataType": "string",
"sourceColumn": "Gender"
},
{
"name": "RaceEthnicity",
"dataType": "string",
"sourceColumn": "RaceEthnicity"
},
{
"name": "IC_PersonID",
"dataType": "int64",
"sourceColumn": "IC_PersonID"
},
{
"name": "StudentNumber",
"dataType": "string",
"sourceColumn": "StudentNumber"
},
{
"name": "StudentName",
"dataType": "string",
"sourceColumn": "StudentName"
},
{
"name": "fullIdentification",
"dataType": "string",
"sourceColumn": "fullIdentification"
},
{
"name": "Sort_idx",
"dataType": "int64",
"sourceColumn": "Sort_idx"
},
{
"name": "Homeless",
"dataType": "string",
"sourceColumn": "Homeless"
},
{
"name": "Refugee",
"dataType": "string",
"sourceColumn": "Refugee"
},
{
"name": "FRL",
"dataType": "string",
"sourceColumn": "FRL"
},
{
"name": "EL",
"dataType": "string",
"sourceColumn": "EL"
}
],
"partitions": [
{
"name": "Dim_Student",
"dataView": "full",
"source": {
"type": "query",
"query": [
"declare @endyear as int = (select endyear from jcps.dbo.schoolyear where active = 1);",
"declare @Today as date = getdate()",
"",
"SELECT st.[DW_PersonID]",
" ,st.[IC_PersonID]",
" ,st.[StudentNumber]",
" ,st.[StudentName]",
" ,st.[fullIdentification]",
" ,st.[Sort_idx]",
" ,st.[Gender]",
" ,st.[RaceEthnicity]",
"\t ,iif(exists(select h.DW_PersonID from DM_StudentAssignment.dbo.Fact_Homeless as h where h.DW_PersonID = st.DW_PersonID and @Today between h.startdate and h.enddate), 'HOMELESS', 'NOT HOMELESS') as 'Homeless'",
"\t ,iif(r.DW_PersonID is not null, 'REFUGEE', 'NOT REFUGEE') as 'Refugee'",
"\t ,UPPER(isnull(f.[LunchCode_Name], 'Paid')) as 'FRL'",
"\t ,CASE ",
"\t\t\tWHEN l.DW_PersonID is not null and programStatus = 'LEP' THEN 'Yes'",
"\t\t\tELSE 'No' END as 'EL'",
"\t ,CASE ",
"\t\t\tWHEN StudentNumber like '%5%' or StudentNumber like '%3%' Then 'Yes'",
"\t\t\tElse 'No' END as 'BigSexy'",
"from [dbo].[Dim_Student] as st",
"left outer join DM_StudentAssignment.dbo.Fact_Refugee as r on st.DW_PersonID = r.DW_PersonID and r.[endYear] = @endyear",
"left outer join DM_StudentAssignment.dbo.Fact_FRL as f on st.DW_PersonID = f.DW_PersonID and f.[endYear] = @endyear",
"left outer join DM_StudentAssignment.dbo.Fact_LEP as l on st.DW_PersonID = l.DW_PersonID and l.[ProgramStatus] = 'LEP'",
"where exists(select fm.DW_PersonID from [dbo].[Fact_CurrentMembership_PupilMonth] as fm where st.DW_PersonID = fm.DW_PersonID and fm.grade between 0 and 20)",
"",
""
],
"dataSource": "Production_DW"
}
}
],
"annotations": [
{
"name": "_TM_ExtProp_DbSchemaName",
"value": "dbo"
},
{
"name": "_TM_ExtProp_QueryDefinition",
"value": [
"declare @endyear as int = (select endyear from jcps.dbo.schoolyear where active = 1);",
"declare @Today as date = getdate()",
"",
"SELECT st.[DW_PersonID]",
" ,st.[IC_PersonID]",
" ,st.[StudentNumber]",
" ,st.[StudentName]",
" ,st.[fullIdentification]",
" ,st.[Sort_idx]",
" ,st.[Gender]",
" ,st.[RaceEthnicity]",
"\t --,iif(h.DW_PersonID is not null, 'HOMELESS', 'NOT HOMELESS') as 'Homeless'",
"\t ,iif(exists(select h.DW_PersonID from DM_StudentAssignment.dbo.Fact_Homeless as h where h.DW_PersonID = st.DW_PersonID and @Today between h.startdate and h.enddate), 'HOMELESS', 'NOT HOMELESS') as 'Homeless'",
"\t ,iif(r.DW_PersonID is not null, 'REFUGEE', 'NOT REFUGEE') as 'Refugee'",
"\t ,UPPER(isnull(f.[LunchCode_Name], 'Paid')) as 'FRL'",
"\t ,CASE ",
"\t\t\tWHEN l.DW_PersonID is not null and isnull(l.parentDeclined,0) = 0 THEN 'EL(ESL)'",
"\t\t\tWHEN l.DW_PersonID is not null and isnull(l.parentDeclined,0) = 1 THEN 'EL(NOT ESL)'",
"\t\t\tELSE 'NOT EL' END as 'EL'",
"from [dbo].[Dim_Student] as st",
"--left outer join DM_StudentAssignment.dbo.Fact_Homeless as h on st.DW_PersonID = h.DW_PersonID and h.[endYear] = @endyear",
"left outer join DM_StudentAssignment.dbo.Fact_Refugee as r on st.DW_PersonID = r.DW_PersonID and r.[endYear] = @endyear",
"left outer join DM_StudentAssignment.dbo.Fact_FRL as f on st.DW_PersonID = f.DW_PersonID and f.[endYear] = @endyear",
"left outer join DM_StudentAssignment.dbo.Fact_LEP as l on st.DW_PersonID = l.DW_PersonID and l.[ProgramStatus] = 'LEP'",
"where exists(select fm.DW_PersonID from [dbo].[Fact_CurrentMembership_PupilMonth] as fm where st.DW_PersonID = fm.DW_PersonID and fm.grade between 0 and 20)"
]
},
{
"name": "QueryEditorSerialization",
"value": [
"<?xml version=\"1.0\" encoding=\"UTF-16\"?><Gemini xmlns=\"QueryEditorSerialization\"><AnnotationContent><![CDATA[<RSQueryCommandText>declare @endyear as int = (select endyear from jcps.dbo.schoolyear where active = 1);",
"declare @Today as date = getdate()",
"",
"SELECT st.[DW_PersonID]",
" ,st.[IC_PersonID]",
" ,st.[StudentNumber]",
" ,st.[StudentName]",
" ,st.[fullIdentification]",
" ,st.[Sort_idx]",
" ,st.[Gender]",
" ,st.[RaceEthnicity]",
"\t --,iif(h.DW_PersonID is not null, 'HOMELESS', 'NOT HOMELESS') as 'Homeless'",
"\t ,iif(exists(select h.DW_PersonID from DM_StudentAssignment.dbo.Fact_Homeless as h where h.DW_PersonID = st.DW_PersonID and @Today between h.startdate and h.enddate), 'HOMELESS', 'NOT HOMELESS') as 'Homeless'",
"\t ,iif(r.DW_PersonID is not null, 'REFUGEE', 'NOT REFUGEE') as 'Refugee'",
"\t ,UPPER(isnull(f.[LunchCode_Name], 'Paid')) as 'FRL'",
"\t ,CASE ",
"\t\t\tWHEN l.DW_PersonID is not null and isnull(l.parentDeclined,0) = 0 THEN 'EL(ESL)'",
"\t\t\tWHEN l.DW_PersonID is not null and isnull(l.parentDeclined,0) = 1 THEN 'EL(NOT ESL)'",
"\t\t\tELSE 'NOT EL' END as 'EL'",
"from [dbo].[Dim_Student] as st",
"--left outer join DM_StudentAssignment.dbo.Fact_Homeless as h on st.DW_PersonID = h.DW_PersonID and h.[endYear] = @endyear",
"left outer join DM_StudentAssignment.dbo.Fact_Refugee as r on st.DW_PersonID = r.DW_PersonID and r.[endYear] = @endyear",
"left outer join DM_StudentAssignment.dbo.Fact_FRL as f on st.DW_PersonID = f.DW_PersonID and f.[endYear] = @endyear",
"left outer join DM_StudentAssignment.dbo.Fact_LEP as l on st.DW_PersonID = l.DW_PersonID and l.[ProgramStatus] = 'LEP'",
"where exists(select fm.DW_PersonID from [dbo].[Fact_CurrentMembership_PupilMonth] as fm where st.DW_PersonID = fm.DW_PersonID and fm.grade between 0 and 20)</RSQueryCommandText><RSQueryCommandType>Text</RSQueryCommandType><RSQueryDesignState></RSQueryDesignState>]]></AnnotationContent></Gemini>"
]
}
]
}
}
}
Hello!
I've inherited a PowerBI app that was developed in 2018, and the developer is no longer at the company. I know very little about PowerBI and less than that about Analysis Services. The Data Source connection is:
I need to add some columns to one of the tables, but the top portion of Transform data is disabled and the only option I can select from the bottom half is Data source settings. Note also that it does not show a Data view on the left-hand side.
If I click Data source settings I get the following set of screens:
So not much help there. At that point I used SQL Server Management Studio, selected Analysis Services as my connection, and typed in the server above. I'm able to see the tables that were created but none of the field names. If I click on the table that I need to add fields to, Student, I can select Partitions. There's only 1 partition created so I click to edit it and can pull up the underlying SQL.
I added a new test field just to see if this would work, BigSexy, and saved it to the partition.
I processed the partition using the mode "Process Full" and it said it successfully completed.
Next I went back to my PowerBI and in the Model View selected Refresh. After the "working on it" message goes away, the new field is not added to my Student table. Does anybody know where I'm going wrong?
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
