Error when importing excel data model into Power BI

Hello @djonesokc,

As for Excel data mode, there are the following restrictions:

• External connections to SQL Server Analysis Services tabular models: In Excel 2013, you can create a connection to SQL Server Analysis Services tabular models and create Power View reports on these models without importing the data. This type of connection is not currently supported as part of importing Excel workbooks into Power BI Desktop. As a workaround, you must recreate these external connections in Power BI Desktop.
• Hierarchies: This type of data model object is not currently supported in Power BI Desktop. Therefore, hierarchies are ignored as part of importing an Excel workbook into Power BI Desktop.
• Binary data columns: This type of data model column is not currently supported in Power BI Desktop. Binary data columns are removed from the resulting table in Power BI Desktop.
• Unsupported Power View Items: There are some features in Power View that are not available in Power BI Desktop, such as themes or certain types of visualizations (scatter plot with playback axis, detailed behaviors, and so on). These unsupported visualizations result in unsupported display messages in their corresponding locations in the Power BI Desktop report, which you can delete or reconfigure as needed.
• Named ranges they use From Table in Power Query or With Excel.CurrentWorkbook in M: Importing this named range data into Power BI Desktop is not currently supported, but this is a planned update. Currently, these named ranges are uploaded to Power BI Desktop as a connection to the external Excel workbook.
• PowerPivot to SSRS: External PowerPivot connections to SQL Server Reporting Services (SSRS) are not currently supported because that data source is not currently available in Power BI Desktop.

Best regards

Liu Yang

If this post helps,then consider Accepting it as the solution to help other members find it faster.