Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
8 years ago

Imported Excel from Sharepoint 365

 

Hi Team , I'm new here in Power BI how to import excel file into Power BI Desktop.
may i ask few quetions : *How we import Excel File in Sharepoint to Power BI ? I tried multiple ways with Link , but it doesn't work  , it always failed and can't find the right excel document. 
*Can Excel File in this sharepoint can be connected and well refreshed in power BI ? means , whether we only need to connect to the internet to refresh the data and publish. it doesn't have any impact to the source of data ? 

Hope to receive your random response very soon. 

Thanks with Best Regards, 
Chanleakna Hang 

Report Server

5 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi Chanleakna123,

     

    You can connect to the Excel via below methods: 

     

    a. Use SharePoint Folder data source, and enter the SharePoint site URL. 

    b. Open the Excel via Excel desktop, and get URL via File -> Info. Use Web data source, enter the URL with ?web=1 removed. See: https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links

     

    After publish the report to Power BI service, if the Excel contains external data source, you might need to configure the gateway, see: https://docs.microsoft.com/en-us/power-bi/refresh-excel-file-onedrive

     

    Best Regards,
    Qiuyun Yu 

     

    • Chanleakna123's avatar
      Chanleakna123
      Post Prodigy
      8 years ago

      Hi Dear v-qiuyu-msft

      I had been tried multiple ways , that my data had been failed to refresh , i'm not sure because our data Data Cridential Source ? 
      I tried Anonymous , Window , OAuth , still failed. 
      this is my first experiment with Sharepoint. 

      Thanks 

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Community Support
        8 years ago

        Hi Chanleakna123,

         

        Please choose OAuth2 authentication and then you should be able to sign in your Sharepoint account. Please clear browser cache and restart browser to test again. 

         

        If issue persists, please click the Show Details and share the screenshot again. 

         

        Best Regards,
        Qiuyun Yu