Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Solution Power BI Service Connecting to OneDrive/Sharepoint for Business

Connecting to OneDrive/Sharepoint for Business

  1. Upload files to the OneDrive for Business for your app workspace

    Please see the following Steps

    1. Go to App.powerbi.com
    2. Create App Workspace
    3. In the Power BI service, select the arrow next to Workspaces > select the ellipsis (…) next to your workspace name.
    4. Select Files to open the OneDrive for Business for your app workspace on Office 365.
    5. Here, you can upload your files to the OneDrive for Business for your app workspace. Select Upload, and navigate to your files.
       
  2. There are Two Method to use the Excel Work book
    1. Import Excel data into Power BI – use the data to build reports and dashboards you can view in a web browser and on mobile devices.
    2. Connect, manage and view Excel in Power BI - display it exactly as it appears in Excel Online
  3. Import or Connect to the files in your app workspace
    1. In Power BI, switch to the app workspace, so the app workspace name is in the top-left corner.
    2. Select Get Data at the bottom of the left navigation pane.
    3. In the Files box, select Get
    4. Select OneDrive - Your App Workspace Name
       
    5. Select the file you want > Connect

      This is the point where you decide whether to import the data from the Excel workbook, or connect to the whole Excel workbooks. Please see B point before C. 

    6. Select Import or Connect
       
      4
    7. If you select Import, then the workbook appears on the Datasets tab.

      If you select Connect, then the workbook is on the Workbooks tab.
       

      Note: Same method will apply for SharePint – TeamSites.


      Thanks and Regards, 
      Farooq K Aziz 
      Snr. Power BI Consultant 
1 ACCEPTED SOLUTION
Anonymous
Not applicable

@v-lid-msft  

 

This is the solution, I posted in the community. Kindly see the below link as well. 

 

https://community.powerbi.com/t5/Issues/Power-BI-Service-connecting-to-OneDrive-Sharepoint-for-Busin...

 

if it is resolved your question. Kindly accept it as solution. 

 

Regards, 

Farooq Aziz 

View solution in original post

3 REPLIES 3
v-lid-msft
Community Support
Community Support

Hi @Anonymous ,

 

Sorry for that, but we cannot understand your requirement clearly, are you occurred error when complete the above ways, or aim to share above solution with community? 

 

As an addition, we can use the Business link in Power BI Desktop to connect multi files based on this document: https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links


Best regards,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

@v-lid-msft  

 

This is the solution, I posted in the community. Kindly see the below link as well. 

 

https://community.powerbi.com/t5/Issues/Power-BI-Service-connecting-to-OneDrive-Sharepoint-for-Busin...

 

if it is resolved your question. Kindly accept it as solution. 

 

Regards, 

Farooq Aziz 

Hi @Anonymous ,

 

Thank you for sharing this wonderful solution, we have learned a lot from it. would you please kindly mark your sharing solution as an answer so that it can benefit more users?


Best regards,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors