Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Column not recognized in DAX measures after datasource change

Hey,

 

I recently changed my datasource to an Azure SQL DB, I kept the column/table names and datatypes the exact same as previous. However, for two of the tables the new columns are not recognized in the original DAX measures even though they are named the same, this is also causing issues in tabular editor and DAX studio.

 

I have worked through the ETL process and can't see any issues throughout, the only thing that seemed to work was changing the column name in power query to the exact same name. Any ideas if this is on the SQL side or an issue with Power Bi? 

Need Help

1 Reply

  • ImkeF's avatar
    ImkeF
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi Anonymous ,
    there are things like unprintable characters that might cause it.
    Have you analyzed the resulting M-code that the renaming has created? This might give a hint as well.
    Personally, I haven't had those issues with Azure SQL yet, works without any issues afaik.