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 Aug 13, 2019 06:56 PM
    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
    ------------------------------
    Conference-PBI_200x200


  • 2.  RE: Invalid credentials

    Posted Aug 14, 2019 12:41 PM
    I have been struggling with the same problem.  I hope someone has a solution.  Thanks.

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

    Conference-PBI_200x200


  • 3.  RE: Invalid credentials

    Bronze Contributor
    Posted Aug 15, 2019 03:42 PM
    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
    ------------------------------

    Conference-PBI_200x200


  • 4.  RE: Invalid credentials

    Gold Contributor
    Posted Aug 16, 2019 07:21 AM
    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
    ------------------------------

    Conference-PBI_200x200


  • 5.  RE: Invalid credentials

    Bronze Contributor
    Posted Aug 16, 2019 02:31 PM
    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
    ------------------------------

    Conference-PBI_200x200


  • 6.  RE: Invalid credentials

    Gold Contributor
    Posted Aug 16, 2019 02:55 PM
    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
    ------------------------------

    Conference-PBI_200x200


  • 7.  RE: Invalid credentials

    Posted Aug 19, 2019 05:48 PM
    Edited by Bruce Ferguson Aug 19, 2019 05:51 PM
    I guess I am having a similar but different problem with a SharePoint List.  I can set the connections up ok but if I later refresh, I get the message "Access to the Resource is Forbidden".  I can reestablish a connection if I go into Date Source Settings and lout out and back in to my Organization Acct. However, I shouldn't have to do this.

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

    Conference-PBI_200x200


  • 8.  RE: Invalid credentials

    Bronze Contributor
    Posted Aug 19, 2019 06:07 PM
    Bruce -
    Any chance this blog entry helps?  https://www.blue-granite.com/blog/power-bi-office-hours-sharepoint-files-lists-folders
    Eric

    ------------------------------
    Eric Lofstrom
    Principal
    BlueGranite Inc.
    elofstrom@blue-granite.com
    Join me each month for Power BI Office Hours!
    https://www.blue-granite.com/power-bi-office-hours
    ------------------------------

    Conference-PBI_200x200