Forum Discussion
Advise request
Hi
I just extracted excel data to bi.
However when i click on close and apply, it is not getting load to the data model. Can you kindly advise the possible reason.
There are no NULL values and data type is also corrected.
Thanks
Sudha
2 Replies
Sreesudha_OC , is there any error it is showing.
Open data transformation mode/ edit query mode. You should see some errors there.
refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTsHi Sreesudha_OC ,
What version of Power BI are you using?
Do you have this issue for any data source? Please have a try that if you import a simple table from excel, will you have this issue?
Please refer this post.
If you get this error: Error: We couldn't find any data in your Excel workbook
You can refer this article:
Please refer the limitations.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-import-excel-workbooks
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
