Importing Data Model from Excel

[Lightice83]

I imported a Data Model from Excel into PBI & now I can see all the queries from the original data model in PBI etc

When I went back & adjusted the original a query in the original Excel data model (added a column in Power Query) this did not flow through to PBI when refreshed

Once you import to PBI do you need to make all query changes through the PBI editor rather than going back to Power Query in Excel?

Thanks

[Dinesh_Suranga]

@Lightice83 

Hi,

What type of changes you did in excel data model?

Thank you.

[Lightice83]

Hi @Dinesh_Suranga  - I added a column in Power Query

[Dinesh_Suranga]

@Lightice83 ,

Please check your ExpandData step in power bi query. May be new column not selected to expand.

Thank you.