how to import data model from Excel

[Anonymous]

 Hi,

i have created an Excel file using merge queries to combine some table. I would like to import the data and power queries to Power BI Desktop. I used File-Import Power Query, Power Pivot. PB shows the migration is successful, but i can't find the data in data view or model view. How can I view those data in PB?

[v-rzhou-msft]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[Anonymous]

Hi Rico, 

sorry for getting back late. It's not related to data loading or refresh setup, i think the problem might relate to the Data Model in Excel itself. I realize that I couldn't open the data model in Excel (got an error message about shortage of memory), that probably explains why data are not imported to PB Desktop. 

[v-rzhou-msft · Accepted solution]

Hi @Anonymous 

You may try to divide your data model to some little ones and try to import the data models into Power Bi Desktop, then you can append the tables by Power Query Editor.

If this reply still couldn't help you to solve your problem, please share more details about the screenshot of your issue, the size of your Excel, the data model of your table.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[amitchandak]

@Anonymous , check are there any pending changes. It should show in the data model after save and exit.

[Anonymous]

No, there is no pending queries. Not sure why no tables are imported. when I click edit query in power BI, I can see all the tables, just can't find them in data view or report view. 

See screenshot below. 

[v-rzhou-msft]

Hi @Anonymous 

Here I have some advice.

1.    Please check whether you trun on the Enable load in Power Bi Editor. 

2. Or you can import your original table into Desktop and merge in Power Query Editor.

If this reply still couldn't help you solve your problem, please tell me more details about your issue.

Show me the screenshot about your dataview.

And you can provide me your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.