2

I am trying to setup a data set in Power BI which can be refreshed on a need basis or scheduled to refresh.

I am uploading an excel workbook which has a power query.

the power query is connecting to Replicon Service to get data via service. the query looks as below:

Source = Web.Contents(
    "https://na2.replicon.com/services/ClientService1.svc/GetActiveClients",
    [
        Headers=
        [
            #"Authorization"="Bearer *ValidToken*",
            #"Accept"="application/json",
            #"Content-Type"="application/json"
        ],  
        Content=Text.ToBinary("{}")
    ]
)

the request is a POST operation and hence Content field is used in Web.Contents Options argument. Authentication is via Bearer token.

Data source setting is Anonymous Credentials with privacy Level set to None.

This works fine and I am able to retrieve the results and even refresh form within workbook.

Once I upload this to PowerBI and attempt to refresh the newly created Dataset it says:

You cannot refresh yet because you need to provide valid credentials for your data sources in the dataset.

So I go to Manage Data sources. Click Edit Credentials. Select "Anonymous" Authentication method and click on Sign In and it says "Login Failed".

Why is that so? It appears that the Headers are lost when I upload the Excel workbook. How can I accomplish this? Is there any alternate ways of being able to set up a Data Set which can be refreshed - the source being a web service?

Improve this question
1

2 Answers 2

Reset to default
1

this is what i ended up doing finally.

my scenario first:

  • my requests are POST
  • Authentication is via bearer token which needed to be passed via Request Header. this was the requirement of the replicon service i am trying to invoke which i couldn't change
  • the dataset that is created in PowerBI needed to be refreshable.

Since i couldn't get it to work directly from inside PowerBI i introduced an intermediate layer. this would interpret GET requests from PowerBI. process the token from query string. accept the service and operation also as query string parameters. it would then create POST request to the Real Service (replicon services in my case). the service name and operation names were also picked up from request URL. the token was pushed as part of request header

so the request from PowerBI would look as PowerBI needed i.e.

Web.Contents("https://intermediatelayer.com?access_token="*validtoken*"&ServiceName="ClientService"&Operation="GetActiveClients"")

not an ideal solution but works.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

Manage Data Sources is validating the Anonymous credentials with a GET request to the URL without the hardcoded headers, like you suggest. It's basically running

Web.Contents("https://na2.replicon.com/services/ClientService1.svc/GetActiveClients")

which fails with "(405): Method Not Allowed", and so Manage Data Sources thinks the credentials are wrong.

Short of making the service reply with a success response for the above M, I don't see any way to set up refresh on this mashup.

Improve this answer

3 Comments

see link in my comment to my question. in that a gentlemen points out that POST isn't supported in PowerBI yet. have you come across relevant info to confirm the same or have got POST working directly from PowerBI?
I agree, Power Query POST for refresh is broken. Power Query probably would need to allow you to manually enter your OAuth token instead of clicking through a browser, and then also understand the POST content when setting up the credentials at Manage Data Sources. Want to share more details for what worked for you as a different answer?
2021, is this still the same, we can't configure POST request for datasource in powerbi?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.