Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Invalid credentials

  • 1.  Invalid credentials

    Bronze Contributor
    Posted 5 days ago
    Created report in Desktop BI. Datasource works fine. Published to app.powerbi , seems OK. Attempt to set refresh schedule and I get the error below.

    ....your data source can't be refreshed because the credentials are invalid. please update your credentials and try again.

    Datasource in Sharepoint. Please help.

    ------------------------------
    Pete Hay
    BI Report Developer
    5034457155
    ------------------------------


  • 2.  RE: Invalid credentials

    Posted 4 days ago
    I have been struggling with the same problem.  I hope someone has a solution.  Thanks.

    ------------------------------
    Bruce Ferguson
    Engineer
    Hunter Industries
    7604021567
    ------------------------------



  • 3.  RE: Invalid credentials

    Bronze Contributor
    Posted 3 days ago
    Problem solved (with the help of MS Tech support).
    Step 1. Excel datasource stored in SharePoint. Do NOT use the SharePoint function to copy the link to the file. You get extraneous characters. Instead, open the file from SharePoint using the Excel desktop application, go to File/Info and copy the path to the file that is listed directly under the filename at the top of the window.
    Step 2. In PowerBI desktop when creating your data connection, do NOT use the Excel connector. Instead, use the "Web" connector. Paste the path that you copied in the previous step to the URL field and use "Organization" as your authentication type. (Organization choice may be listed as "Oauth" depending on the dialog box).
    This allowed me to set the refresh in the PowerBI web app.

    ------------------------------
    Pete Hay
    BI Report Developer
    503-445-7155
    ------------------------------



  • 4.  RE: Invalid credentials

    Gold Contributor
    Posted 2 days ago
    Hi all,

    Patrick covered this issue (or a closely related issue) in this video on Guy In  A Cube.
    Useful to watch and only 3 minutes.

    https://www.youtube.com/watch?v=t4TzHu8THoA


    ------------------------------
    Jessica Jolly
    ALT-Enter, LLC
    312/617-9134
    Jessica.Jolly@altentertraining.com
    ------------------------------



  • 5.  RE: Invalid credentials

    Bronze Contributor
    Posted 2 days ago
    I just watched the video and yes, it perfectly describes the solution arrived upon by MS Tech Support after 2 long hours on phone support.
    Thank you Jessica

    ------------------------------
    Pete Hay
    BI Report Developer
    503-445-7155
    ------------------------------



  • 6.  RE: Invalid credentials

    Gold Contributor
    Posted 2 days ago
    That's why I really try to keep up on my Guy In A Cube videos. I am currently a couple of months behind but am working to get caught up on them!

    ------------------------------
    Jessica Jolly
    ALT-Enter, LLC
    312/617-9134
    Jessica.Jolly@altentertraining.com
    ------------------------------