topic Re: how to push data trough api in Developer

how to push data trough api

Anonymous — Wed, 06 Nov 2019 13:47:39 GMT

Hello,

I'm following this tutorial:
https://docs.microsoft.com/fr-fr/power-bi/developer/walkthrough-push-data

I choosed a native application type in the first step, what should I use for the different uri in the second step? in the native mode, you have only the clientID
https://docs.microsoft.com/fr-fr/power-bi/developer/walkthrough-push-data-get-token

//RedirectUri you used when you register your app.
           //For a client app, a redirect uri gives Azure AD more details on the application that it will authenticate.
           // You can use this redirect uri for your client app
           string redirectUri = "https://login.live.com/oauth20_desktop.srf";

           //Resource Uri for Power BI API
           string resourceUri = "https://analysis.windows.net/powerbi/api";

           //OAuth2 authority Uri
           string authorityUri = "https://login.microsoftonline.net/common/";

Thanks for your answer

Re: how to push data trough api

Jayendran — Thu, 07 Nov 2019 07:44:59 GMT

Hi @Anonymous ,

The Redirect url become valid only for the Web app type registration. Since you used native you can use the one which provided in the code itself

string redirectUri = "https://login.live.com/oauth20_desktop.srf";

Re: how to push data trough api

Anonymous — Thu, 07 Nov 2019 15:25:01 GMT

Hi @Jayendran ,

Thanks for you answer, for the resourceUri, I shloud keep the follownig line?

string resourceUri = "https://analysis.windows.net/powerbi/api";

I had the window for loggin/password but when I click on the button to connect, I have the following message

Re: how to push data trough api

Jayendran — Thu, 07 Nov 2019 16:01:52 GMT

Hi @Anonymous ,

Ok the document is out-dated. Please follow my instruction as below

1. Update the nuget package manager for the Microsoft.IdentityModel.Clients.ActiveDirectory

Install-Package Microsoft.IdentityModel.Clients.ActiveDirectory -Version 4.5.1.0

2. update your code like below

AuthenticationContext authContext = new AuthenticationContext(authorityUri); //update with your master account email and password var userCreds = new UserPasswordCredential("UserName@MyTenent.onMicrosoft.com", "myEasyToCrackPassword"); var userAuthnResult = authContext.AcquireTokenAsync(resourceUri, clientID, userCreds).Result; string token=userAuthnResult.AccessToken;

You don't need the redirect url at all.

ResourceUri and authorityurl remains same as

string resourceUri = "https://analysis.windows.net/powerbi/api"; //OAuth2 authority Uri string authorityUri = "https://login.microsoftonline.com/common/";

Re: how to push data trough api

Anonymous — Fri, 08 Nov 2019 08:49:09 GMT

@Jayendran Thank you very much!

It works, I have the token et I create the dataset but it doesn't work when I add rows as in this step:

https://docs.microsoft.com/en-us/power-bi/developer/walkthrough-push-data-add-rows

Re: how to push data trough api

Anonymous — Fri, 08 Nov 2019 08:56:13 GMT

I found the answer here:

https://community.powerbi.com/t5/Developer/Step-4-Get-a-dataset-to-add-rows-into-a-Power-BI-table-Example/m-p/115221#M3970

Re: how to push data trough api

Jayendran — Fri, 08 Nov 2019 09:14:09 GMT

Hi @Anonymous ,

Glad that you solved your issue and also provided the link. I hope it will help sombody in the future too 😊

Thanks

Re: how to push data trough api

Anonymous — Fri, 08 Nov 2019 11:03:50 GMT

I try to delete the rows I created, but I have a timeout... Is it only possible to delete the dataset? not rows it contains? thanks

Re: how to push data trough api

Anonymous — Tue, 12 Nov 2019 08:07:37 GMT

Hello!

To go further, I would like to refresh my data through API:
The first time, I add rows in the dataset I created, as explain before.

Once done, I would like to empty (or delete) the dataset to send new data

@Jayendran, if you can help me, thanks in advance 🙂

Re: how to push data trough api

Jayendran — Tue, 12 Nov 2019 10:05:11 GMT

Hi @Anonymous ,

Could you please check whether the below conditions

Also I couldn't able to read the error properly as the screenshot not in english

Re: how to push data trough api

Anonymous — Thu, 14 Nov 2019 14:34:32 GMT

Hi @Jayendran ,

It works with the deleteRowsInGroup; it seems a workspace is necessary...

thanks again