Power BI REST API no-code options

[@SoheilBakhshinz]

Perfect timing Adam. It's not a long time that I'm looking at the Powwer BI REST APIs and I absolutely love it. The possibilities are endless.

[@GuyInACube]

Woot! Yeah i love that the Try It feature was added to the rest api. I also like that it helps to generate the URL so you don't have to necessarily think about that from the PowerShell side of things. Or regular code for that matter.

[@truenorth6686]

Adam, Try it is gone in this April. any recommend alternative way to easy use PowerBi api?

[@adiroy265]

Adam, can we use REST API to pull data into Power BI desktop as of 2020 ?

[@gauravsukhadia638]

@@The_Internet_Is_Overrated Hi guys I am also looking for the same. Did any one of you found solution ? I know how to do it in Power Query but technically I would have to refresh that query or whole report in order to get the result populated. I was more looking into if somehow we can embed API dynamic link + API key inside DAX and bring the result as per requested id.

[@CharudattaAmbekar]

You can also get the output of Powershell in a .csv file.

[@GuyInACube]

Very true! 👊

[@SolutionsAbroad]

Wow great options! You're giving me ideas now on how we can programatically refresh our reports!

[@Fernando-hr1ix]

Hey Adam! do you have any idea what happened to the try it button that the API documentation had? I think I missed some update, I used to remove dataset from usage metrics reports when its update got stuck.

[@websutracode5544]

Could you advise how can we genera the authorization code without using the Microsoft login prompt? I have the user credentials stored in the app and would like to silently login using username and password. The biggest problem is the account has MFA enabled.

[@smarty420ful]

How do I get the bearer token using an API as if i manually copy paste it after every 1hr it changes.. Could you please help?

[@olivierflageul4563]

Hello ! Is it possible to send a command via API REST to print in PDF an embedded report ? Or is it something not supported yet ? I found nothing about it! Many thanks !

[@tijl1234]

I have a question: is there and API call for retrieving the Schema of a PowerBI dataset? I looked everywhere bit could not find it...

[@JamieWillisRose]

Can I use the Refresh Dataset in Group API from Flow? I want to force my Power BI report to refresh when the data source is updated (SharePoint).

[@SoheilBakhshinz]

Yes you can. You'll need to create a custom connector in Flow pointing to Power BI Rest APIs. This link might be helpful: medium.com/@Konstantinos_Ioannou/refresh-powerbi-dataset-with-microsoft-flow-73836c727c33

[@learningspace6816]

I have an API which will generate output in json format, how can I configure the api and it's bearer token in powerbi desktop application?

[@liljatheodorsdottir2291]

Hi there, Great video. I have a question though; is there any ways to retrieve paginated reports and the workspace they are in? Cheers, Lilja

[@DataSpinners]

Hi Adam - Love this - Any way of use creating a Flow that calls the APIs?

[@angeljmartel]

Hello! great video!Do you know by any chance if there is a REST api to get the CONTACT of a PBI report? I just find the one about CreatedBy which is not giving me what I want! Thanks!!

[@stefanq3514]

We have 100 ish reports that get data from on prem SSAS via gateway, and have no easy way of knowing which report will be affected if we change a cube because there is currently no reporting like this in the service which is disappointing. The REST api can be used to fill this gap, but its a significant piece of work. To automate this programatically, dealing with the oAuth2 and token is a nightmare and of course you need to register your app and have appropriate access on the tenant which is a BIG drama at large companies. To make life WAY easier, it would be great if the data like workspaces, reports, dashboards, datasets, gateways, users etc. could be dumped automatically daily into a dataflow dataset that you could query with Power BI and not have to write REST code to do all this.

[@arunavasarkar3744]

I wanted to use the PowerShell script but there's no download option to the link that is mentioned!!

[@utkarshsharma8105]

how to get the list of email ids by RLS roles using REST APIs. Please guide here

[@azureman8279]

Hi Adam, Any idea how we can import Notebooks using Rest API? I tried by taking a reference from official documentation but its not working.

[@danagelotte46]

Excellent Video. Question - Is there a Rest API or set of PowerShell CmdLets, which can be used to run a PowerBI Report and Export the Report results? Thank you, Dana

[@andres777video]

Thanks Adam, very interesting use of REST with Power BI. I'm looking into how to automate Report Migrations from Dev/Test into Power BI Service Prod, this combination of PBI API and PowerShell seems to be the right way to do it.

[@fazilkians]

If we need to do the reverse, load the data from a web service using REST API. Can we do it ? How?

[@roybudhaditya1726]

Yes, we can. try web connection

[@SusmithaRavishankar]

Hey Adam, Can you help me how to use a Scroll API with Recursion in PowerBI

[@zubairshams1986]

Is there a way to use the use the built in HTTP action in Flow to trigger the API for group data refresh? I tired it and got an error in Flow, so not sure if I need to take some extra steps.

[@avinashm7181]

Hi, Can you show REST API creating in dataflows

[@ЮлианГантман]

Is it possible to automate export of a report or a dataset to Excel file with REST API and PowerShell?

[@SoheilBakhshinz]

What you need is not API I believe. Check the link below, while it is not exactly what you are after, but it may help you implementing something similar for exporting to Excel: www.biinsight.com/exporting-power-bi-data-to-sql-server/ You can also use DAX Editor if the dataset you're trying to export to Excel is published to a Workspace that is backed by Premium capacity. This maybe helpful if that's the case: www.biinsight.com/quick-tips-export-power-bi-desktop-and-power-bi-service-model-data-as-a-whole-with-dax-studio/ Besides all of the above, you can always analyse your datasets in Excel, well, if you're allowed to.:)

[@GuyInACube]

There is not a REST API to export data. Typically i hear this in the context of programatically generating a PDF. Or, referred to as the Print option. There are a few idea items out there on this. I'd recommend voting them up. One is marked as planned but that was from back in 2016 - ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12288612-print-and-export-embedded-reports-through-rest-api. Another has a little bit of a higher vote - ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/35066698-export-to-pdf-via-power-bi-embedded-api

[@jacobdecker8652]

Adam Thanks for the video. I've been hitting my head around if we can use slicer selections values to pass as an API parameter or even as a variable parameter to a SQL stored procedure? Sorry if that question doesn't necessarily fit the topic of your video but it was the closest thing i could find.

[@After9to5]

Hello Adam, I don't have the try it button to try it. I already logged in.

[@karthikkumaresan6787]

Can u explain how to post rows to the dataset

[@thingstodowithBASS]

Great summary breakdown! thanks for posting

[@quentinwinisdoerffer421]

Hey Adam! Thanks for this video, Same as below, could we use these APIs directly in PowerQuery? As a jsondocument(Web.component()) ? I'm trying to do it but i cannot find the good way to configure access to the datasource....

[@jerrybulauan5963]

Will this work with PIPEDRIVE?

[@bbrr999]

Adam, could you cover the area where we can use 'service principle' account to refresh dataset? . I believe it is not straight forward

[@jameswar12]

Hey Adam, in the PowerShell code you have a Login-PowerBI statement. Would that work in an SSIS package or does someone have to physically login with their username/password when that part of the command runs? Thanks for all these videos, they are fantastic!

[@devalmeida]

Use the -Credentials in Login-PowerBI parameter to set the username/password.

[@marcusvincent3023]

@@devalmeida can you elaborate on this a little bit? FYI: I'm building a python requests script to achieve this.

[@devalmeida]

Hi @@marcusvincent3023! I dont know how to create this implementation with python. But... See this powershell code for practice an logic: #Create secure password $userPassword = ConvertTo-SecureString "{YOUR-PASSWORD}" -AsPlainText -Force #Create credentials with secure password $credentials = New-Object System.Management.Automation.PSCredential("{YOUR-MAIL}", $userPassword) # Login with the credentials programmatically Login-PowerBI -Credential $credentials Enjoy!

[@pritichaudhari7596]

how to get Data from RESTful API which has "two Factor Authentication" e.g. Maconomy RESTful API framework.

[@priyadua7617]

Great Video Adam! Can we use the rest API without code to get metadata from Talend to Power BI?

[@malosephaka9069]

Hi Adam I'm stuck with this problem, I am querying an API that only allows you to bring back 10 records at a time. Then you have to do another call and provide the next page key to get the next batch of 10 records and so forth. Is there a way for Power BI to use a variable to pull in the next page key from the response, and then use it in the API call to cycle through the data till the end of the data.

[@uniQue_XL]

Thank you very much Adam. Great video!

[@GuyInACube]

Appreciate that! 👊

[@eugenegarrett1156]

I could not find a download for the Power Shell code.

[@erinfield1943]

Is this video about how to make an API go faster? What video do i watch to make the API refresh faster?

[@giri41]

Adam please show us how to audit the tenant by user by month in a power bi report thanks

[@MrBharath205]

Thanks for this video Adam, I wanted to make a call from power bi slicer to databricks and output of databricks has to be seen in power bi ,. Can you pls suggest!!

[@sanjithkumararvee1028]

is possible to export the report using api for sending out as email? (already answered below, thanks)

[@MrUbbers]

Great video and clear explanation! How would I go about retrieving a list of users that have access to an App (not the App Workspace)?

[@GuyInACube]

The Get App API doesn't expose the user assignment, and $expand isn't supported on it currently. I'm not aware of a way to get this programmatically at this time. docs.microsoft.com/en-us/rest/api/power-bi/apps/getapp

[@IAMHOCKEY]

Hello, First off, OMG I have learned so much from you two. Thank you for everything!! Hoping you can help I have a cloud service that uses client ID and client secret plus api uses. I want to pull this data into Bi desktop. I have not been able to get PowerBI.to the service? I tried the “for web” option but have not been successful. The API is fully documented as well. Not sure how to get the data to bi and have it refresh often as I need to know when certain records are created? I have looked at all your videos and can’t find one that explains this type setup. Thank you

[@russellpadilla377]

Where do i find that shirt?

[@marcusvincent3023]

How can we generate an API token so we can run these calls though python requests etc. ?

[@subhashchandramahato]

How to configure power Bi gateway for dynamic rest API?

[@hemanthbanty6187]

Hi, will this work even for the Desktop Power BI

[@haddyDrow1]

How? Desktop doesn't have the place where you can take the connection string from. How did you get it?

[@osuravinuperera]

Hello Adam, can you show me how to connect Azure APIs to Power BI ? I'm trying to have a live translation to my survey report, is that even possible?

[@tinabachova]

Hi Adam, great video again! Thanks. I was wondering if there is anything like this for Power BI apps - all I can find in the MS documentation is REST API on Get Groups but that only gives me a list of apps - not a list of users that can access it. I tried to use $expand parameter here as well, but it did not work. Any suggestions, please? Thank you!

[@terrancetatum7599]

I'm brand new to Power BI. I want to make a simple POST request to a REST API. It doesn't seem possible using this tool. I've found a article on the web that describes how easy it is to transform the default get method using the Text.ToBinary function. My ideal of easy and Microsoft's are apparently very different. I guess a simple dropbox selection is too much to ask for?

[@GuyInACube]

I'm not sure i understand. It sounds like you are trying to do the POST from within Power Query? That wasn't the intention of this video.

[@SuperDougwilson]

Is there a postman collection available?

[@kdivyeh04]

Hi Adam, Great video Just wanted what is the number of call limit per day for dataset refresh api limit for premium capacity.?

[@MrUbbers]

48 times a day for Premium capacity according to the blog post; powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/

[@GuyInACube]

The Refresh API limit should have been lifted with the release of the XMLA read endpoint. The UI still has the limit of 48 time for scheduled refresh.

[@mbhatamb]

Adam there is no video which explains how to create a JWT embed token for a from Java, if you can create one

[@marlonnucci809]

Has anyone found a solution to get the conversation id? can someone help me?

[@victorrojo2005]

Great video, I am new with this tecnology and I have problems exporting a report like you do in the video in the minute 2:30, I fill the report Id but it is not working, it return an answer code "404" and I don't know why, because it seems so simple. I tried to do the same with Export Report in Group, filling the information and after a long time processing, it return an answer code "500". My report has a reportsection, I don't know if this affects. Thanks

[@ahv5457]

Hi, I am getting data from an API that has two parameters like below in the URL: Param1930=2021-01-01&Param1931=2030-12-31&format=JSON These are the start and end dates of the report that I have manfully set up in the API URL. But, how do I make it dynamic so that everyday that I refresh the data in Power BI connect to the API and pull the latest data? My current M code is something like below: let Source = Json.Document(File.Contents("C:\Users\Ali\AppData\Local\Microsoft\Windows\INetCache\IE\EHD7MHFN\1120")), #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"txtProvider", "txtIncidentNo", "FltDate", "LogTime")

[@vitaliburla8498]

Thanks a lot - that was very interesting to watch.

[@eagillum]

How do I find someone who can help me with my Power BI question? Do you do tech calls?

[@chandradeepm]

How to get the dataset name, data source name, what gateway they used, what is the database name used

[@maharshichattopadhyay8355]

Hi, I am new to Power Bi and I was hoping you could help me solve a very specific use case. So I have a made Power BI dashboard which I want to export to a PPT or a PDF. However I want to embed multiple dashboard into 1 file and don’t want to generate more than 1 file. I have a case id and 10 different cases so I want to filter the dashboard and generate 10 different dashboards based on every case id and then put all of it into 1 report. And I want this process to be automated without any manual intervention. Can you guide me through the steps? Thanks in advance.

[@ulysses3183]

Is it possible to do python command lets?

[@papudalai5069]

Hi Adam I'm facing problem during api integrating in power bi. The DMS team provide me the API but when use that in web it's showing an error like "A web API key can only be specified when a web API key name is provided. Could you make a video on that with free API

[@bobbyjones6634]

Hey, off-topic question, does anyone know if it is possible to add a button that can perform its action without holding Control key. (Pressing the button with just the left click and not with ctrl+lmb)

[@GuyInACube]

Within Power BI Desktop, you need to do the CTRL+Click. This is really a design mode issue. When published to the service, it would just be a regular click without the use of CTRL. This is because within Desktop, a regular click is a selection of the visual itself.

[@dantepraxedis]

So cool, actually it is what I was looking for

[@musofttechlearning]

How can I publish reports using API?

[@christopherjstanley]

I can get the members of the Workspace, but is there any way to get the list of who has access to the App?

[@alt-enter237]

See above--I think the answer is no.

[@sujitkadam8386]

Hi Adam, nice video and explanation. Have you tried using REST APIs with POST/ PATCH command (includes JSON body).... using Service principal authentication. Let me know if you know any pointers. Thanks

[@sushantjadhav3011]

Hi Adam, Can we get the dimensions and measures of a chart in power bi using rest api?

[@GuyInACube]

Unfortunately no. Not at this time at least. Be sure to get something over at ideas.powerbi.com. On the Power BI Premium side, you could do something with the XMLA endpoint.

[@elizabethtachjian8151]

Hi Adam, Any chance you can do a video on how to refresh data on a dataflows please. Refresh data to occur just the one time. I use a SharePoint register dataflows data to create a dataset in Power BI desktop. I have never used Power BI Rest API hence a simple video to introduce the capability will be amazing.

[@madhupnetfundu]

power Bi tile not displaying contents from office planner.Our requirement is to view office planner content in power BI page. We are using tiles with link set to office planner however we end up having error message "The content cant be displayed in Iframe".Is there any other method to enable displaying content in tiles.thanks..Please guide..

[@GuyInACube]

Not overly familiar with Planner. Maybe look to see if they have a special embed url for their content? I know KZbin has something like that. If you try to use a full KZbin URL in an , bad things will happen. Using the embed URL for a KZbin video works better. This is also the case for using the embedded content in a published App. Something to look into.

[@angelo4664]

Is it possible to refresh PowerBI with multi-factor authentication through API? I tend to save the credentials in the code but is not very safe and if the company has a policy of MFA is not currently possible - only disabling MFA for that particular user.

[@SoheilBakhshinz]

If you're gonna use APIs in an app then what about app passwords for MFA? I haven't tested this method myself, but it might be doable. support.office.com/en-us/article/create-an-app-password-for-office-365-3e7c860f-bda4-4441-a618-b53953ee1183

[@GuyInACube]

This is where service apps come into play. I've done this and it works really well. This is the way too get around the MFA issue. docs.microsoft.com/power-bi/developer/embed-service-principal

[@BIDiamantes]

It works on the WEB, but in Jupyter it returns the following error: "Error when performing query: 401 {'error': {'code': 'PowerBINotAuthorizedException', 'pbi.error': {'code': 'PowerBINotAuthorizedException', 'parameters': {}, 'details': [], 'exceptionCulprit': 1}} }"

[@mejaay4077]

@Adam, @ Guy in a Cube , can you pls put video how to integrate with Angular 7+ framework pls.. I'm not able to understand few documents.. there's some package outdated issues is there.. kindly help us on this

[@MuhammadBerki]

Brilliant video thanks

[@sajinabraham2726]

can please any one tell me.why we use powerbi restapi use

[@raz8657]

Hi Adam, this is a perfect video, However, I don't see Try-it feature- even after signed in with my company ID, Is that something I am missing ...

[@raz8657]

I am sorry - I guess i need to register the app first to work with API

[@stevehearne]

'Try it' has gone 😞

[@CookiesDarkMatter]

Inability to read from the dataset through the rest API is bizarre.

[@GuyInACube]

I've heard requests before to be able to extract data from the REST API. I think the direction the product team is going is to really look at the XMLA endpoints for that and just use normal AS connectivity, as opposed to lighting that up from the REST API. I could definitely see value in having that ability from the REST API, although I also know people would abuse it and could potentially add unneeded overhead on the service.

[@gulhermepereira249]

Great tutorial, luv u

[@wrekkingcru]

Adam - Excellent info and presentation style. Also - where the heck did you get that sweet spaceship timeline t-shirt? I'd like to buy that one, but can't find the same shirt you're wearing that has the Tardis correctly in blue at the top and bottom. If you can reply with a link to where you bought that would be hugely appreciated!!! :) Thanks!

[@chamilam]

Thank you so much ...

[@shutdown-rnownow9202]

good stuff

[@eugeniopazrodriguez8911]

Shows me an error 403

[@quackanator166]

🐐

powerrr

[@luckyprod9013]

apart from the "yoooooooo", thank you so much for your channel :) (please skip the "yoooooooo" part :) )

[@MrUbbers]

It is a signature, I like it :-)

[@ghazanfarabidi4137]

My 3 year old loves the catchphrase! Gotta keep it.

[@sergejschaab7287]

Yoooop is the best part ;)

[@raz8657]

Even, I like that ..

[@andres777video]

I scared me at first (as I was not expecting it), but now I like it.

[@tareqzaman5728]

HI Adam , I want to know in PBI service can you use post method . I have 6 API calls and I am using Bearer token to get the most recent data. Data is refreshing in PBI desktop when i hit refresh button with new data comes in . However, i am facing issue ( API Calls is passing the token values i am calling in post method in power query first ) when i publish it and want to schedule the page refresh. It throws me dataset credential error . it seems like it's not taking token for those API Calls. If you have any solution then please let me know or provide me your email to discuss more . Thanks