Forum Discussion
how to import data model from Excel
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?
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.
6 Replies
- amitchandak
Super User
Anonymous , check are there any pending changes. It should show in the data model after save and exit.
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.
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
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.
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.
