Data loading issue_CSV_XLX

[Muhammadirfan20]

Hi community! I am learning Power BI. I am facing issue for loading data. Direct loading is not supported, when i click on "Transform data" it opened, and i clean it, after that, when i click on apply, error showed there on main interface, all the screemshots are attached. Please help to get rid of this problem. Thank you for your cooperation

[Muhammadirfan20]

Did not get solution yet 

[grazitti_sapna]

Hi @Muhammadirfan20,

What is the source of excel you are loading?

Some connectors (like Web, OData, Google Sheets, API endpoints, Oracle Fusion, etc.) do not support DirectQuery, only Import mode.

In Power BI Desktop:
Home → Get Data → (your source)
When prompted, select Import instead of DirectQuery.

Also check that the credential and connector information is correct.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

[danextian]

Hi @Muhammadirfan20 

CSV, Excel files and other flat files do not support direct query but import mode only.