Import of Power query from Sharepoint

[Anonymous]

I couldn't import the Power query or Data models (Excel) from sharepoint into Power BI. When I try to import the Power query, it shows "Windows cannot find. Check spelling and try again" error. But the same link works fine in excel. Please anyone help me with the solution.

Thanks in advance

[amitchandak]

@Anonymous , Are you trying like ?

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-import-excel-workbooks

https://sqldusty.com/2015/08/20/importing-a-power-pivot-model-power-view-into-power-bi/

[Anonymous]

@amitchandak Thanks for the reply. 

Actualy I have workbook (no table) with only created connections and data model.

When I try to import as Power Query, it shows the error "Windows cannot find. Please check spelling and try again".

When I try to import it through web, it shows me only the Power pivot data (not data models).

[amitchandak]

@Anonymous , I am confused. Is there a model in excel or not.

if there is no model, then you need to follow this approach to get excel URL  from SharePoint(same as onedrive)

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links

[Anonymous]

@amitchandak Yeah, I have Data model inside excel, but not able to import it into Power BI from sharepoint.