Forum Discussion

ifat_c's avatar
ifat_c
Helper I
5 years ago

changing the column type in SQL server require re-import to the table

Hi,
I'm using an Azure SQL server Data source with a direct query model

I had to change a specific column type in the SQL and unfortunately, the simple refresh from the "transform data" section is not sufficient and the data doesn't appear properly in my model.

I found that only a complete reload of the table to the report accepts all the relevant changes.

 

is there another way to do it? cause it requires me to set all the measures and calculated columns again, remove the old table, change the data fields in the different visuals, etc... very frustrating. (simple refresh does not cut it!) 

 

Need Help

2 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    Hi ifat_c 

    Create another query that brings in your data from Azure and does the required transformations.  The table that results from this query is used as the source for your original query.

    Modify the original query source step to load the table from the new query.

    Regards

    Phil

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    Hi ifat_c 

    Which data type is this column when you use it in your report (visuals, measures...)? Did you try inserting a step in Power Query Editor to transform this column into the data type you need in the report? DirectQuery models support adding Power Query steps to convert data types. Have a try!

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.