Power Pivot data model import into Power BI desktop issue

[mancich]

When I try to import my Excel Power Pivot data model into Power BI deskptop, I get and error that says "Migration Completed with 1 warning" When I hover my mouse over the information icon next to CombinedPacks in the image below, it says "this query isn't currently supported".

What can cause this type of issue? The CombinedPacks query coming over from Excel is a Power Query query that I made sure to add to the Data Model when I ran it. The CombinedPacks queryt is the fact table, so obviously crucial.

Thank you

 

[Matt Allington]

It’s not an error, it’s a warning. Warnings normally are advisory and will still work. do you have the latest version of PBID? Maybe that’s the issue. Regardless, you should be able to right click the query in the query pane (in Excel), copy, and past i to the query pane in PBID. If that doesn’t work, copy the code from the Advanced Editor in Excel into the Advanced Editor in PBID

 

[mancich]

Thank you I'll try that