cancel
Showing results for 
Search instead for 
Did you mean: 

Migrate data model from Excel Power Pivot

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

Status: New
Comments
v-lili6-msft
Community Support

hi  @sam_xlpowerbi 

I have tested on my side, it works well.

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

9.JPG

 

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
Frequent Visitor

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
Frequent Visitor

@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
Community Support

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
Frequent Visitor

@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
Frequent Visitor

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

v-lili6-msft
Community Support

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
Frequent Visitor

@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