Failed to save modification to the server

[Anonymous]

Hello,

i have the following error when trying to import data from SQL.
if you check the below image its saying "fromDay in table SupervisorCommision cannot be found".

i imported same table earlier and put a new column in it RELATED to another table. now, its not possible to create this from Query editor.
any Suggestion. ?

[selimovd]

Hey @Anonymous ,

the error message says there is a problem with the column "fromDay". Can you check the data source if that column exists or has problems?

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

The Data Source does not have "fromDay"

earlier, i imported same data set and made a new column in data view with the following dax :

fromDay = RELATED(Period[fromDay])
due to some other problems i removed the tables AreaManagerComission and Supervisor Comission, and re imported them. now i cant creat the fromDay column because its not accepting loading data without first giving him the fromDay column. 

[v-easonf-msft]

Hi， @Anonymous 

As the table structure of your original data source has been changed, you may need to recheck each applied step in Power query editor.

You can also consider creating a new report to connect to the data source, and then you can replace the original query with the new query.

Best Regards,
Community Support Team _ Eason