Forum Discussion

Chanleakna123's avatar
Chanleakna123
Icon for Post Prodigy rankPost 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 ...
Report Server
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity 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
    Icon for Post Prodigy rankPost 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
      Icon for Community Support rankCommunity 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 

      • Chanleakna123's avatar
        Chanleakna123
        Icon for Post Prodigy rankPost Prodigy
        8 years ago

        Hi , the message shown above. i have no idea what's wrong with this. 
        Any solution on this part ? 

         

        thanks with Regards, 

        Leakna