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
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.
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
@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
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.
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)
@v-lili6-msft - were you able to replicate this issue - any update
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.
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