Data import for analysis

[Ranjanamahajan]

I am using iPad to learn power BI. 

I am trying to import XL fie, but not able to do it. I am not even able to paste data manually from XL . Any help

[v-karpurapud]

Hi @Ranjanamahajan 

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[v-karpurapud]

Hi @Ranjanamahajan 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-karpurapud]

Hi @Ranjanamahajan 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-karpurapud · Accepted solution]

Hi @Ranjanamahajan 

Thank you for reaching out to the Microsoft Fabric Community Forum.

Regarding the issue with import an Excel file into Power BI and paste data manually from Excel,  are failing on an iPad are due to platform and Power BI’s functionality.

Power BI on iPad is limited to viewing reports and does not support importing Excel files or pasting data manually. Features like "Get Data" and "Enter Data" are not available in the mobile app, and importing files from the iPad’s local storage isn't supported.
About mobile-optimized Power BI reports - Power BI | Microsoft Learn

 Manual data entry is only possible through Power BI Desktop or in a browser using Power BI Service, but not reliably on an iPad. The best workaround is to upload Excel files to OneDrive or SharePoint and access them through Power BI Service in a supported browser as suggested by @tharunkumarRTK .

 

Since manually pasting data into Power BI is not supported on iPad as no “Enter Data” feature in the mobile app or reliable clipboard support in the browser, you can create a table in Power BI Service(browser).

If this response resolves your query, kindly mark it as Accepted Solution to help other community members. A Kudos is also appreciated if you found the response helpful.
 

Thank You!

[tharunkumarRTK]

@Ranjanamahajan 

Since you cannot install Power BI desktop on Mac OS or iPad OS I am assuming you are using Power BI web. (not the power bi app on app store)

Upload your excel file in sharepoint / one drive. Copy the file URL from the details pane. Open app.powerbi.com from your browser and then click on create tab. Click on 'Excel (preview)' option and paste the URl you copied. It should work. 

When it comes to manual copy paste, I am using mac book and power bi web and it is working perfectly fine. I am not sure but may be try connecting your ipad to the keyboard and try with the key board commands.

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!