Migrate data model from Excel Power Pivot

[sam_xlpowerbi]

After the Nov 2020 update (2.87.923.0) When you click on File - Import - Power Query, Power Pivot....

The Migration fails with an error Object refrence not set to an instance of an object

This keeps happening every now and then after an update.

Any ideas why this is happening

Cheers

Sam

[v-lili6-msft]

hi  @sam_xlpowerbi 

I have tested on my side, it works well.

My version is 2.87.923.0 64-bit (November 2020) too.

I would suggest you create a support ticket to let engineers look into the issue on your side. 

and as a workaround, you may try to roll back PowerBI desktop to the version of Oct to see if it works well. 

https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive

Regards,

Lin

[sam_xlpowerbi]

Hi Lin - Please try it with the attached file - works fine in the older releases of Power bI desktop fails when I try and do the same thing in the Nov release 

The File Dashboard_RLS has the queries and the Data model

The File DB.xlsx is the source data

https://1drv.ms/u/s!AiKBTsYfZw-vg7AFWX_YCBnNoqCXrg?e=b0XnEE

Best Regards

Sam

[sam_xlpowerbi]

@v-lili6-msft - I figured out where the problem is.

If your Data model has a Table that is directly imported using "Add To Data Model" then Power BI Desktop seems to have forgotten how to import such tables

Kindly fix this issue

[v-lili6-msft]

hi  @sam_xlpowerbi 

I used "Add To Data Model" to add a table in the mode, it still works well.

my power bi desktop is Version: 2.87.1061.0 64-bit (November 2020)

you may have a try the latest version.

Regards,

Lin

[sam_xlpowerbi]

@v-lili6-msft 

To replicate the issues - you need to have atleast two tables one from "Add To Data Model" the other via PQ

Kindly test using the below file (called 2TABLES.xlsx)

https://1drv.ms/u/s!AiKBTsYfZw-vg7AFWX_YCBnNoqCXrg?e=b0XnEE

[sam_xlpowerbi]

@v-lili6-msft  - were you able to replicate this issue - any update

[v-lili6-msft]

hi @sam_xlpowerbi 

Sorry for late reply, I didn't notice your reply, and I test on your sample file 2TABLES.xlsx, it couldn't be imported into power bi, but when I tested on my excel file, but not replicate this issue.

here is my excel file, please try it see if it works well on your side.

Regards,

Lin

[sam_xlpowerbi]

@v-lili6-msft 

As mentioned to replicate this issue - Just create a Excel Table with one row and one column

Click on the button Add To Data Model - don't use  copy paste 

Save the File

Using Power Query - Import one Table from an External Source - Add this table to the Data Model.

Try and import this in to Power BI - It will faill

Cheers

Sam