web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Not able to connect Ex...
Customer experience | Sales, Customer Insights,...
Suggested Answer

Not able to connect Excel file to create the data source in Dynamics 365 Customer Insights.

(0) ShareShare
ReportReport
Posted on by Hughes64 10

Hi folks,

I am trying to create a data source in Dynamics 365 customer insights that connect with excel file. I stored in the OneDrive also tried from Sharepoint. But it's giving error that Invalid credentials. Please help me out to resolve this issue.

pastedimage1594706083681v1.png

Thanks 

Arun

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Arun,

    I have experienced this issue for SharePoint in the past when connecting to Power Query for both Customer Insights and Power BI.  I have not tried to connect to a file in OneDrive from Power Query before but I would think the solution is very similar.

    • I issue has to do with the "File Path or URL" that you are using to reference the file in SharePoint.
    • If you simply use the Copy Link button in SharePoint then you will experience this issue and your copied file link URL will look something like the one below.

             pastedimage1594834787949v3.png

             XXX.sharepoint.com/.../ERSO4qHaCplLitwI8a7CaCkBs3OtgLWRxJsMXrAnzoPxQQ

    • To fix the issue and get the correct file URL you need to select the correct file in SharePoint, select the vertical dots next to the file as shown below and then chose Details at the very bottom of the menu.

            pastedimage1594834704929v2.png

    • This will open the Files Details screen on the right side of the SharePoint window, scroll to the bottom and select the Copy Direct Link button next to Path.  

               pastedimage1594835207610v4.png

    • This will copy the correct URL file path to use and you should not get the same issue when you use it in the Power Query connection wizard.  Your copied URL should look similar to this.

                https://XXX.sharepoint.com/sites/CustomerInsights/Shared%20Documents/Yammer.xlsx

    Please mark this as a Verified Answer if it answers your question.

    Thanks,

    Scott Roller

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 189 Super User 2026 Season 1

#2
CU11031447-0 Profile Picture

CU11031447-0 100

#3
NeerajPawar Profile Picture

NeerajPawar 66

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans