none
OData queries on Project Online, from Power BI Desktop and from Excel RRS feed

  • Question

  • Hi, 

    1-Connection  from Power BI Desktop :

    From one PC with Windows 7, I can connect easily on my OData database with Power BI Desktop.
    From another PC with Windows 10, I try the same connection but I always get the error:  Access to the resource is forbidden.
    What could be the issue ?

    2- Connection from Excel :

    On the portable PC with Windows 10, I used to make OData connections from Excel. They worked fine some months ago.
    To day, with this same PC, in Excel, I get exactly the same credential dialog box as Power BI Desktop (same look) and unfortunately the same error : Access to the resource is forbidden.
    The Excel file is on the hard disk of my laptop. I can access it, and I can refresh some previous OData queries. But I cannot create a new one : Access to the resource is forbidden!

    Any idea?

    Thanks


     
    Sunday, February 26, 2017 5:44 PM

Answers

All replies

  • Hello,

    Can you take Power BI Desktop and Excel out of the equation and navigate to the PWA site in Internet Explorer then once the PWA homepage successfully loads navigate to the OData feed by typing the correct URL, for example <PWA Site URL>/_api/ProjectData/Projects Does that load data in the browser or do you get the access forbidden message there too on the Win 10 machine?

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Sunday, February 26, 2017 8:23 PM
    Moderator
  • easiest think I've ever heard.

    good luck

    Sunday, February 26, 2017 8:36 PM
  • Hello Paul,

    I did that on the 2 PCs:

    Win 7 : I got a large page of xml data !

    Win 10 : 404 NOT FOUND

    Sunday, February 26, 2017 8:55 PM
  • OK - Win 7 is correct. On Win 10 did the PWA homepage load successfully?

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Sunday, February 26, 2017 8:57 PM
    Moderator
  • Yes, the homepage loads successfully and quickly on Win 10. 
    Sunday, February 26, 2017 9:04 PM
  • On Win 10 once the PWA homepage has loaded remove the default.aspx from the URL leaving the last / and type _api/ProjectData/Projects

    Assuming the same thing works on the Win 7 PC with the same user account there is no reason it wont work on the Win 10 PC.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Sunday, February 26, 2017 9:08 PM
    Moderator
  • You are right : I made a typo in "_api/ProjectData/Projects". Sorry.

    Once corrected, I got a very large xml page on Win 10.


    • Edited by WLID1966 Sunday, February 26, 2017 9:18 PM
    Sunday, February 26, 2017 9:17 PM
  • Great - so there is no issue with the Project Online OData feed. The issue is with the credentials used in Excel or Power BI Desktop. Sounds like there are stored credentials that are not correct and Power BI Desktop / Excel client is just using those instead of prompting you to enter the correct details/ Or do Power BI Desktop / Excel prompt for username and password? Can you access Project Online using the Project desktop client on the Win 10 PC?

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Sunday, February 26, 2017 9:21 PM
    Moderator
  • Project Pro on Win 10 can access Project Online.

    I installed Power BI Desktop today on the Win 10 PC. Before that, Excel never demanded a user name nor password for OData queries. Now it demands such credentials via a dialog box which has the typical look of Power BI dialogs.

    Sunday, February 26, 2017 9:38 PM
  • OK, if the same credentials are used it should work.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    • Marked as answer by WLID1966 Sunday, February 26, 2017 10:01 PM
    Sunday, February 26, 2017 9:57 PM
    Moderator
  • I'll check the credentials.

    Thanks a lot!

    Sunday, February 26, 2017 10:01 PM