{"id":59,"date":"2016-09-19T15:06:13","date_gmt":"2016-09-19T15:06:13","guid":{"rendered":"http:\/\/coding.agust.org\/?p=59"},"modified":"2016-11-25T15:19:02","modified_gmt":"2016-11-25T15:19:02","slug":"authenticating-odata-source-on-powerbi-com","status":"publish","type":"post","link":"https:\/\/coding.agust.org\/index.php\/2016\/09\/19\/authenticating-odata-source-on-powerbi-com\/","title":{"rendered":"Authenticating OData source on powerbi.com"},"content":{"rendered":"

Working on reports published to powerbi.com where the data comes through OData from Azure. Found that oAUth2 has to be used as credentials for each of the datasource on powerbi.com Also, for queries that depend on other queries – you may see that you need to fix the authentication of those before the child is resolved. For example below, you can see that the third from bottom has been fixed, but not the one below. As I proceed fixing the credentials for each one, eventually they will all be fixed.<\/p>\n

\"OData<\/p>\n

    \n
  1. Click on [Edit credentials]<\/li>\n
  2. Select oAuth2 – and log in with the correct credentials.<\/li>\n
  3. If it does not work – select the next one.<\/li>\n<\/ol>\n

    On the screen where you pick authentication method\u00a0you can see the url of the datasource being configured:<\/p>\n

    \"OData<\/p>\n

    Click here to read MS documentation on this topic.<\/a><\/p>\n

     <\/p>\n","protected":false},"excerpt":{"rendered":"

    Working on reports published to powerbi.com where the data comes through OData from Azure. Found that oAUth2 has to be used as credentials for each of the datasource on powerbi.com Also, for queries that depend on other queries – you may see that you need to fix the authentication of those before the child is … Continue reading “Authenticating OData source on powerbi.com”<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[9],"class_list":["post-59","post","type-post","status-publish","format-standard","hentry","category-powerbi","tag-authentication"],"_links":{"self":[{"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/posts\/59","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/comments?post=59"}],"version-history":[{"count":4,"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/posts\/59\/revisions"}],"predecessor-version":[{"id":65,"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/posts\/59\/revisions\/65"}],"wp:attachment":[{"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/media?parent=59"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/categories?post=59"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/tags?post=59"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}