{"id":27360,"date":"2018-09-06T03:30:28","date_gmt":"2018-09-06T03:30:28","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=27360"},"modified":"2018-09-11T15:25:44","modified_gmt":"2018-09-11T09:55:44","slug":"rest-api-in-power-bi","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/rest-api-in-power-bi\/","title":{"rendered":"REST API in Power BI &#8211; Dataset, Import, Reports, Push Datasets"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:1782,&quot;href&quot;:&quot;https:\\\/\\\/docs.microsoft.com\\\/en-us\\\/rest\\\/api\\\/power-bi&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20220901202428\\\/https:\\\/\\\/docs.microsoft.com\\\/en-us\\\/rest\\\/api\\\/power-bi\\\/&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-10 00:03:47&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-16 11:44:27&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-20 16:25:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-25 13:54:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-12 18:43:18&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-21 11:24:41&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-26 01:01:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-01 15:55:27&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-06 03:23:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-09 03:41:53&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-24 21:46:45&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-04 06:35:32&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-30 16:15:12&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-13 09:53:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-12 14:10:05&quot;,&quot;http_code&quot;:206}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-06-12 14:10:05&quot;,&quot;http_code&quot;:206},&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<h2>1. Objective<\/h2>\n<p>In our previous two tutorials, we covered most of the Power BI REST API through\u00a0<a href=\"https:\/\/data-flair.training\/blogs\/power-bi-api\/\"><strong>Part -1<\/strong><\/a> &amp; <strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-rest-api\/\">Part &#8211; 2<\/a><\/strong>. Today, in this REST API in Power BI we are going to discuss Power BI\u00a0Imports API, Power BI Push Datasets API,\u00a0Power BI Reports API, and\u00a0Power BI Datasets API.<br \/>\nSo, let&#8217;s start REST API in Power BI.<\/p>\n<div id=\"attachment_27376\" style=\"width: 1212px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/REST-API-in-Power-BI-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-27376\" class=\"wp-image-27376 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/REST-API-in-Power-BI-01.jpg\" alt=\"REST API in Power BI - Dataset, Import, Reports, Push Datasets\" width=\"1202\" height=\"630\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/REST-API-in-Power-BI-01.jpg 1202w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/REST-API-in-Power-BI-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/REST-API-in-Power-BI-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/REST-API-in-Power-BI-01-768x403.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/REST-API-in-Power-BI-01-1024x537.jpg 1024w\" sizes=\"auto, (max-width: 1202px) 100vw, 1202px\" \/><\/a><p id=\"caption-attachment-27376\" class=\"wp-caption-text\">REST API in Power BI &#8211; Dataset, Import, Reports, Push Datasets<\/p><\/div>\n<h2>2. REST API in Power BI<\/h2>\n<p>Following are the Power BI REST APIs. let&#8217;s discuss them:<\/p>\n<ul>\n<li>Operation group Description<\/li>\n<li>Admin Operations<\/li>\n<li>Available Features<\/li>\n<li>Capacities Operations<\/li>\n<li>Dashboards Operations<\/li>\n<li>Embed Token Operations<\/li>\n<li>Gateways Operations<\/li>\n<li>Groups Operations<\/li>\n<li><strong>Imports Operations<\/strong><\/li>\n<li><strong>Push Datasets Operations<\/strong><\/li>\n<li><strong>Reports Operations<\/strong><\/li>\n<li><strong>Datasets Operations<\/strong><\/li>\n<\/ul>\n<h2>3. Power BI Datasets API<\/h2>\n<p>These are the Datasets\u00a0Operations of REST API in Power BI:<br \/>\n<strong>a. Bind To Gateway<\/strong><br \/>\nTies the predefined dataset from &#8220;My Workspace&#8221; to the predetermined portal. These exclusive backings the On-Premises Data Gateway.<br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-gateway\/\">Do you know about Power Bi Gateway?<\/a><\/strong><br \/>\n<strong>b. Tie To Gateway In Group<\/strong><br \/>\nTies the predefined dataset from the predetermined workspace to the predefined portal. Supported for the On-Premises Data Gateway.<br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong>c. Erase Dataset By Id<\/strong><br \/>\nErases the predefined dataset from &#8220;My Workspace&#8221;.<br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong>d. Erase Dataset By Id In Group<\/strong><br \/>\nErases the predefined dataset from the predetermined workspace.<br \/>\n<strong>Required Extension: Dataset<\/strong>.ReadWrite.All<br \/>\n<strong>e. Find Gateways<\/strong><br \/>\nReturns a rundown of portals which the predefined dataset from &#8220;My Workspace&#8221; can be bound to.<\/p>\n<ul>\n<li>This REST API in Power BI is applicable just for datasets that have no less than one on-premises association.<\/li>\n<li>For datasets with cloud-just associations, it will restore a vacant rundown.<\/li>\n<\/ul>\n<p><strong>Required Degree:<\/strong> Dataset.Read.All<br \/>\n<strong>f. Find Gateways In Group<\/strong><br \/>\nReturns a rundown of entryways that the predetermined dataset from the predefined workspace can be bound to.<\/p>\n<ul>\n<li>This REST API in Power BI is pertinent just for datasets that have no less than one on-premises association.<\/li>\n<li>For datasets with cloud-just associations, it will restore an unfilled rundown.<\/li>\n<\/ul>\n<p><strong>Required Extension:<\/strong> Dataset.Read.All<br \/>\n<strong>g. Get Dataset By Id<\/strong><br \/>\nReturns the predetermined dataset from &#8220;My Workspace&#8221;.<br \/>\n<strong>Required Degree:<\/strong> Dataset.ReadWrite.All or Dataset.Read.All<br \/>\n<strong>h. Get Dataset By Id In Group<\/strong><br \/>\nReturns the predetermined dataset from the predefined workspace.<br \/>\n<strong>Required Degree:<\/strong> Dataset.ReadWrite.All or Dataset.Read.All<br \/>\n<strong>i. Get Datasets<\/strong><br \/>\nReturns a rundown of datasets from &#8220;My Workspace&#8221;.<br \/>\n<strong>Required Degree:<\/strong> Dataset.ReadWrite.All or Dataset.Read.All<br \/>\n<strong>j. Get Datasets In Group<\/strong><br \/>\nReturns a rundown of datasets from the predetermined workspace.<br \/>\n<strong>Required Degree:<\/strong> Dataset.ReadWrite.All or Dataset.Read.All<br \/>\n<strong>k. Get Datasources<\/strong><br \/>\nReturns a rundown of datasources for the predetermined dataset from &#8220;My Workspace&#8221;.<br \/>\n<strong>Required Degree:<\/strong> Dataset.ReadWrite.All or Dataset.Read.All<br \/>\n<strong>l. Get Datasources In Group<\/strong><br \/>\nReturns a rundown of datasources for the predefined dataset from the predetermined workspace.<br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All or Dataset.Read.All<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-administrator-portal\/\">Follow this link to know about Power BI Administrator Portal<\/a><\/strong><br \/>\n<strong>m. Get Gateway Datasources<\/strong><br \/>\nReturns a rundown of passage datasources for the predetermined dataset from &#8220;My Workspace&#8221;.<br \/>\n<strong>Note:<\/strong> <em>Use the new Dataset &#8211; Get Datasources API.<\/em><br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All or Dataset.Read.All<br \/>\n<strong>n. Get Gateway Datasources In Group<\/strong><br \/>\nReturns a rundown of portal datasources for the predetermined dataset from the predefined workspace.<br \/>\n<strong>Note:<\/strong> <em>Use the Dataset &#8211; Get Datasources In Group API.<\/em><br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All or Dataset.Read.All<br \/>\n<strong>o. Get Parameters<\/strong><br \/>\nReturns a rundown of parameters for the predefined dataset from &#8220;My Workspace&#8221;.<br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong>p. Get Parameters In Group<\/strong><br \/>\nReturns a rundown of parameters for the predefined dataset from the predetermined workspace.<br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong>q. Get Refresh History<\/strong><br \/>\nReturns the revive history of the predefined dataset from &#8220;My Workspace&#8221;.<br \/>\n<strong>Required Degree:<\/strong> Dataset.ReadWrite.All or Dataset.Read.All<br \/>\n<strong>r. Get Refresh History In Group<\/strong><br \/>\nReturns the revive history of the predefined dataset from the predetermined workspace.<br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All or Dataset.Read.All<br \/>\n<strong>s. Invigorate Dataset<\/strong><br \/>\nTriggers an invigorate for the predetermined dataset from &#8220;My Workspace&#8221;.<br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong>t. Invigorate Dataset In Group<\/strong><br \/>\nTriggers an invigorate for the predetermined dataset from the predefined workspace.<br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong>u. Set All Dataset Connections<\/strong><br \/>\nUpdates all associations for the predefined dataset from &#8220;My Workspace&#8221;.<br \/>\n<strong>Note:\u00a0<\/strong><em>To refresh association subtle elements for SQL, AS, OData Feed, and SharePoint, utilize Update Datasources. For other datasource composes, utilize Update Parameters.<\/em><br \/>\nThis REST API in Power BI is just backings SQL DirectQuery datasets.<br \/>\n<strong>Required Degree:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-pricing\/\">Have a look at Power BI Pricing &amp; Power BI Licensing<\/a><\/strong><br \/>\n<strong>v. Set All Dataset Connections In Group<\/strong><br \/>\nUpdates all associations for the predetermined dataset from the predefined workspace.<br \/>\n<strong>Note:\u00a0<\/strong><em>To refresh association points of interest for<a href=\"https:\/\/data-flair.training\/blogs\/sql-tutorial\/\"><strong> SQL<\/strong><\/a>, AS, OData Feed, and SharePoint, utilize Update Datasources In Group. For other datasource composes, utilize Update Parameters In Group.<\/em><br \/>\nThis REST API in Power BI is just backings SQL DirectQuery datasets.<br \/>\n<strong>Required Degree:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong>w. Assume control In Group<\/strong><br \/>\nExchanges responsibility for a determined dataset to the currently approved client.<br \/>\n<strong>Required Degree:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong>x. Refresh Datasources<\/strong><br \/>\nUpdates the datasources of the predetermined dataset from &#8220;My Workspace&#8221;.<br \/>\n<strong>Imperative:<\/strong>\u00a0<em>The first datasource and the new datasource must have precisely the same.<\/em><br \/>\nFor reserved models, the dataset must be invigorated to get the information from the new information sources. Sit tight 30 minutes for the refresh datasources activity to finish before reviving.<br \/>\n<strong>Required Degree:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong>Confinements &#8211;\u00a0<\/strong>Refresh datasources bolsters SQL Server, Azure SQL Server, Analysis Services, Azure Analysis Services, OData Feed, and SharePoint datasources. For other datasource composes, utilize Update Parameters<\/p>\n<ul>\n<li>Changing datasource compose isn&#8217;t bolstered.<\/li>\n<li>Datasources that contain parameters on the association string are not upheld.<\/li>\n<li>Datasources which are a piece of Merged or Joined tables are not upheld.<\/li>\n<li>Changing association from a cloud to on-premises or on-premises to a cloud isn&#8217;t bolstered.<\/li>\n<\/ul>\n<p><strong>y. Refresh Datasources In Group<\/strong><br \/>\nUpdates the datasources of the predetermined dataset from the predefined workspace.<br \/>\n<strong>Vital:\u00a0<\/strong>The first datasource and the new datasource must have precisely the same.<br \/>\nFor reserved models, the dataset must be invigorated to get the information from the new datasources. Sit tight 30 minutes for the refresh datasources activity to finish before reviving.<br \/>\n<strong>Required Degree:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong>Confinements &#8211;\u00a0<\/strong>Refresh datasources bolsters SQL Server, Azure SQL Server, Analysis Services, Azure Analysis Services, OData Feed, and SharePoint datasources. For other datasource composes, utilize Update Parameters In Group.<\/p>\n<ul>\n<li>Changing datasource compose isn&#8217;t upheld.<\/li>\n<li>Datasources that contain parameters on the association string are not upheld.<\/li>\n<li>Datasources which are a piece of Merged or Joined tables are not upheld.<\/li>\n<li>Changing association from cloud to on-premises or on-premises to cloud isn&#8217;t upheld.<\/li>\n<\/ul>\n<p><strong>z. Refresh Parameters<\/strong><br \/>\nUpdates the parameters esteem for the predefined dataset from &#8220;My Workspace&#8221;.<br \/>\n<strong>Imperative:<\/strong> The dataset must be revived for new parameters esteems to be connected. Sit tight 30 minutes for the refresh parameters task to finish before invigorating.<br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/\">Do you know How to Create Your Own Measures in Power BI Desktop<\/a><\/strong><\/p>\n<h3>i. Limitations<\/h3>\n<ul>\n<li>All parameters must exist in the dataset. Names are case-touchy.<\/li>\n<li>Datasets with SQL, Oracle, Teradata and SapHana Direct Query associations are not bolstered.<\/li>\n<li>Datasets with Analysis Services Live associations are not bolstered.<\/li>\n<li>Greatest of a 100 parameters in ask for is permitted.<\/li>\n<li>Qualities ought to be of expected Type.<\/li>\n<li>Can&#8217;t pass void an incentive to an IsRequired parameter.<\/li>\n<li>Rundown can&#8217;t be vacant or incorporate numerous events of the same parameter.<\/li>\n<li>Parameters of sorts &#8216;Any&#8217; or &#8216;Parallel&#8217; can&#8217;t be set.<\/li>\n<li>Parameters may change the real association (server or potentially database), however not its OnPrem status (from Cloud to OnPrem, or the other way).<\/li>\n<\/ul>\n<h2>4. Power BI Import API<\/h2>\n<p><strong>a. Make Temporary Upload Location<\/strong><br \/>\nMakes a transitory blob stockpiling to be utilized to import .pbix records bigger than 1 GB.<br \/>\nTo import .pbix documents bigger than 1 GB, make a transitory transfer area and transfer the record utilizing the mutual access signature (SAS) url from the reaction, and afterwards call Post Import and determine &#8216;fileUrl&#8217; to be the SAS url in the Request Body<br \/>\n<strong>Note:<\/strong> <em>Import huge .pbix documents is accessible for workspaces on a premium limit.<\/em><br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong>b. Make Temporary Upload Location In Group<\/strong><br \/>\nMakes an impermanent blob stockpiling used to import .pbix documents bigger than 1 GB.<br \/>\nTo import .pbix documents bigger than 1 GB, make a transitory transfer area and transfer the .pbix record utilizing the common access signature (SAS) url from the reaction, and afterwards call Post Import In Group and determine &#8216;fileUrl&#8217; to be the SAS url in the Request Body.<br \/>\n<strong>Note:<\/strong> <em>Import huge .pbix records is accessible for workspaces on <\/em>a premium<em> limit.<\/em><br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong>c. Get Import By Id<\/strong><br \/>\nReturns the predetermined import from &#8220;My Workspace&#8221;.<br \/>\n<strong>Required Degree:<\/strong> Dataset.ReadWrite.All or Dataset.Read.All<br \/>\n<strong>d. Get Import By Id In Group<\/strong><br \/>\nReturns the predefined import from the predetermined workspace.<br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All or Dataset.Read.All<br \/>\n<strong>e. Get Imports<\/strong><br \/>\nReturns a rundown of imports from &#8220;My Workspace&#8221;.<br \/>\n<strong>Required Degree:<\/strong> Dataset.ReadWrite.All or Dataset.Read.All<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/data-sources-for-power-bi\/\">Read about Data Sources for Power BI Benefit (Services)<\/a><\/strong><br \/>\n<strong>f. Get Imports In Group<\/strong><br \/>\nReturns a rundown of imports from the predefined workspace.<br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All or Dataset.Read.All<br \/>\n<strong>g. Post Import<\/strong><br \/>\nMakes new substance on &#8220;My Workspace&#8221; from .pbix, Excel or record way in OneDrive for Business.<br \/>\n<strong>Required Degree:<\/strong> Dataset.ReadWrite.All<br \/>\n<b>Notes- <\/b><em>To import a record, ask for Headers ought to incorporate Content-Type: multipart\/frame information with the document encoded as shape information in the demand body.<\/em><\/p>\n<ul>\n<li>To import from OneDrive for Business, ask for Headers ought to incorporate Content-Type: application\/json with ImportInfo in the demand body.<\/li>\n<li>To import .pbix records bigger than 1 GB, see Create Temporary Upload Location, supported just for workspaces on a\u00a0premium limit.<\/li>\n<\/ul>\n<p><strong>h. Post Import In Group<\/strong><br \/>\nMakes new substance on the predetermined workspace from .pbix, Excel, or record the way in OneDrive for Business.<br \/>\n<strong>Required Degree:<\/strong> Dataset.ReadWrite.All<br \/>\n<b>Notes &#8211;\u00a0<\/b><em>To import a document, ask for Headers ought to incorporate Content-Type: multipart\/shape information with the record encoded as frame information in the demand body.<\/em><\/p>\n<ul>\n<li>To import from OneDrive for Business, ask for Headers ought to incorporate Content-Type: application\/json with ImportInfo in the demand body.<\/li>\n<li>To import .pbix documents bigger than 1 GB see Create Temporary Upload Location In Group, supported just for workspaces on a premium limit.<\/li>\n<\/ul>\n<h2>5. Power BI Push Datasets API<\/h2>\n<p>REST API in Power BI &#8211; Datasets API<br \/>\n<strong>a. Datasets DeleteRows<\/strong><br \/>\nErases all columns from the predefined table inside the predetermined dataset from &#8220;My Workspace&#8221;.<br \/>\n<strong>Note:<\/strong>\u00a0<em>This REST API in Power BI is bolstering just Push datasets<\/em>.<br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-building-blocks\/\">Follow this link to know about Power BI Building Blocks<\/a><\/strong><br \/>\n<strong>b. Datasets DeleteRowsInGroup<\/strong><br \/>\nErases all lines from the predefined table, inside the predetermined dataset, from the predetermined workspace.<br \/>\n<strong>Note:<\/strong> <em>This REST API in Power BI is underpine just Push datasets.<\/em><br \/>\n<strong>Required Degree:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong>c. Datasets GetTables<\/strong><br \/>\nReturns a rundown of tables inside the predetermined dataset from &#8220;My Workspace&#8221;.<br \/>\n<strong>Note:<\/strong> <em>This REST API in Power BI is bolstering just Push datasets.<\/em><br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All or Dataset.Read.All<br \/>\n<strong>d. Datasets GetTablesInGroup<\/strong><br \/>\nReturns a rundown of tables inside the predefined dataset from the predetermined workspace.<br \/>\n<strong>Note:<\/strong> <em>This REST API in Power BI is underpins just Push datasets.<\/em><br \/>\n<strong>Required Degree:<\/strong> Dataset.ReadWrite.All or Dataset.Read.All<br \/>\n<strong>e. Datasets PostDataset<\/strong><br \/>\nMakes another dataset on &#8220;My Workspace&#8221;.<br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong>f. Datasets PostDatasetInGroup<\/strong><br \/>\nMakes another dataset in the predetermined workspace.<br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong>g. Datasets PostRows<\/strong><br \/>\nAdds new information columns to the predetermined table inside the predefined dataset from &#8220;My Workspace&#8221;.<br \/>\n<strong>Note:<\/strong> <em>This REST API in Power BI is underpinning just Push datasets.<\/em><br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong>h. Datasets PostRowsInGroup<\/strong><br \/>\nAdds new information lines to the predefined table, inside the predetermined dataset, from the predetermined workspace.<br \/>\n<b>Note: <\/b><em>This\u00a0REST API in Power BI is bolstering just Push datasets.<\/em><br \/>\n<strong>Required Degree:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-security\/\">Do you know What is Dynamic Row-Level Security in Power BI?<\/a><\/strong><br \/>\n<strong>i. Datasets PutTable<\/strong><br \/>\nUpdates the metadata and outline for the predefined table inside the predetermined dataset from &#8220;My Workspace&#8221;.<br \/>\n<strong>Note:<\/strong> <em>This REST API in Power BI is bolsteringjust Push datasets.<\/em><br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All<br \/>\n<strong>j. Datasets PutTableInGroup<\/strong><br \/>\nUpdates the metadata and construction for the predefined table, inside the predetermined dataset, from the predefined workspace.<br \/>\n<strong>Note:<\/strong> <em>This REST API in Power BI underpins just Push datasets.<\/em><br \/>\n<strong>Required Extension:<\/strong> Dataset.ReadWrite.All<\/p>\n<h2>6. Power BI Reports API<\/h2>\n<p>REST API in Power BI &#8211; Reports API<br \/>\n<strong>a. Clone Report<\/strong><br \/>\nClones the predefined report from &#8220;My Workspace&#8221;.<br \/>\n<strong>Required Extension:<\/strong> Content.Create<br \/>\n<strong>b. Clone Report In Group<\/strong><br \/>\nClones the predetermined report from the predefined workspace.<br \/>\n<strong>Required Degree:<\/strong> Content.Create<br \/>\n<strong>c. Erase Report<\/strong><br \/>\nErases the predetermined report from &#8220;My Workspace&#8221;.<br \/>\n<strong>Required Extension:<\/strong> Report.ReadWrite.All<br \/>\n<strong>d. Erase Report In Group<\/strong><br \/>\nErases the predefined report from the predetermined workspace.<br \/>\n<strong>Required Degree:<\/strong> Report.ReadWrite.All<br \/>\n<strong>e. Fare Report<\/strong><br \/>\nFares the predetermined report from &#8220;My Workspace&#8221; to a .pbix document.<br \/>\n<strong>Required Degree:<\/strong> Report.ReadWrite.All or Report.Read.All<br \/>\n<strong>f. Fare Report In Group<\/strong><br \/>\nFares the predetermined report from the predefined workspace to a .pbix record.<br \/>\n<strong>Required Extension:<\/strong> Report.ReadWrite.All or Report.Read.All<br \/>\n<strong>g. Get Report<\/strong><br \/>\nReturns the predefined report from &#8220;My Workspace&#8221;.<br \/>\n<strong>Required<\/strong>\u00a0<strong>Extension:<\/strong> Report.ReadWrite.All or Report.Read.All<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-report-server\/\">Let&#8217;s discuss Power BI Report Server in detail<\/a><\/strong><br \/>\n<strong>h. Get Report In Group<\/strong><br \/>\nReturns the predetermined report from the predefined workspace.<br \/>\n<strong>Required<\/strong>\u00a0<strong>Extension:<\/strong> Report.ReadWrite.All or Report.Read.All<br \/>\n<strong>i. Get Reports<\/strong><br \/>\nReturns a rundown of reports from &#8220;My Workspace&#8221;.<br \/>\n<strong>Required Extension:<\/strong> Report.ReadWrite.All or Report.Read.All<br \/>\n<strong>j. Get Reports In Group<\/strong><br \/>\nReturns a rundown of reports from the predetermined workspace.<br \/>\n<strong>Required Degree:<\/strong> Report.ReadWrite.All or Report.Read.All<br \/>\n<strong>k. Rebind Report<\/strong><br \/>\nRebinds the predetermined report from &#8220;My Workspace&#8221; to the asked for a dataset.<br \/>\nRequired Degree: Report.ReadWrite.All<br \/>\n<strong>l. Rebind Report In Group<\/strong><br \/>\nRebinds the predefined report from the predetermined workspace to the asked for a dataset.<br \/>\n<strong>Required Degree:<\/strong> Report.ReadWrite.All<br \/>\n<strong>m. Refresh Report Content<\/strong><br \/>\nUpdates the predefined report from &#8220;My Workspace&#8221; to have indistinguishable substance from the report in the demand body.<br \/>\n<strong>Required Degree:<\/strong> Report.ReadWrite.All<br \/>\n<strong>n.\u00a0Refresh Report Content In Group<\/strong><br \/>\nUpdates the predefined report from the predetermined workspace to have indistinguishable substance from the predetermined report in the demand body.<br \/>\n<strong>Required Extension:<\/strong> Report.ReadWrite.All<br \/>\nSo, this was all about REST API in Power BI. Hope you like our explanation.<\/p>\n<h2>7.\u00a0Conclusion<\/h2>\n<p>Hence, in this Power BI tutorial, we learned about different operations of REST API in Power BI: Power BI\u00a0Imports API, Power BI Push Datasets API,\u00a0Power BI Reports API, and\u00a0Power BI Datasets API. Still\u00a0have a doubt, feel free to ask in the comment section.<br \/>\nRelated Topic &#8211; <strong><a href=\"https:\/\/data-flair.training\/blogs\/arcgis-maps-for-power-bi\/\">Power BI\u00a0ArcGIS Maps<\/a><\/strong><br \/>\n<strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/rest\/api\/power-bi\/\">For reference<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Objective In our previous two tutorials, we covered most of the Power BI REST API through\u00a0Part -1 &amp; Part &#8211; 2. Today, in this REST API in Power BI we are going to&#46;&#46;&#46;<\/p>\n","protected":false},"author":5,"featured_media":27376,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[992,9597,9667,9746,9813,9836,9837,11585],"class_list":["post-27360","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-bi","tag-api-in-power-bi","tag-power-bi-api","tag-power-bi-datasets-api","tag-power-bi-import-api","tag-power-bi-push-datasets-api","tag-power-bi-reports-api","tag-power-bi-rest-api","tag-rest-api-in-power-bi"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>REST API in Power BI - Dataset, Import, Reports, Push Datasets - DataFlair<\/title>\n<meta name=\"description\" content=\"REST API in Power BI - Power BI Reports API, Power BI Push Datasets API, Power BI Import API, Power BI Datasets API, Power BI API with examples\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/rest-api-in-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"REST API in Power BI - Dataset, Import, Reports, Push Datasets - DataFlair\" \/>\n<meta property=\"og:description\" content=\"REST API in Power BI - Power BI Reports API, Power BI Push Datasets API, Power BI Import API, Power BI Datasets API, Power BI API with examples\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/rest-api-in-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-06T03:30:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-09-11T09:55:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/REST-API-in-Power-BI-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1202\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"REST API in Power BI - Dataset, Import, Reports, Push Datasets - DataFlair","description":"REST API in Power BI - Power BI Reports API, Power BI Push Datasets API, Power BI Import API, Power BI Datasets API, Power BI API with examples","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/rest-api-in-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"REST API in Power BI - Dataset, Import, Reports, Push Datasets - DataFlair","og_description":"REST API in Power BI - Power BI Reports API, Power BI Push Datasets API, Power BI Import API, Power BI Datasets API, Power BI API with examples","og_url":"https:\/\/data-flair.training\/blogs\/rest-api-in-power-bi\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-09-06T03:30:28+00:00","article_modified_time":"2018-09-11T09:55:44+00:00","og_image":[{"width":1202,"height":630,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/REST-API-in-Power-BI-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/rest-api-in-power-bi\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/rest-api-in-power-bi\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"REST API in Power BI &#8211; Dataset, Import, Reports, Push Datasets","datePublished":"2018-09-06T03:30:28+00:00","dateModified":"2018-09-11T09:55:44+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/rest-api-in-power-bi\/"},"wordCount":2489,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/rest-api-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/REST-API-in-Power-BI-01.jpg","keywords":["API in Power BI","Power BI API","Power BI Datasets API","Power BI Import API","Power BI Push Datasets API","Power BI Reports API","Power BI REST API","Rest API in Power BI"],"articleSection":["Power BI Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/rest-api-in-power-bi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/rest-api-in-power-bi\/","url":"https:\/\/data-flair.training\/blogs\/rest-api-in-power-bi\/","name":"REST API in Power BI - Dataset, Import, Reports, Push Datasets - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/rest-api-in-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/rest-api-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/REST-API-in-Power-BI-01.jpg","datePublished":"2018-09-06T03:30:28+00:00","dateModified":"2018-09-11T09:55:44+00:00","description":"REST API in Power BI - Power BI Reports API, Power BI Push Datasets API, Power BI Import API, Power BI Datasets API, Power BI API with examples","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/rest-api-in-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/rest-api-in-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/rest-api-in-power-bi\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/REST-API-in-Power-BI-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/09\/REST-API-in-Power-BI-01.jpg","width":1202,"height":630,"caption":"REST API in Power BI - Dataset, Import, Reports, Push Datasets"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/rest-api-in-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SAS Foundation Tools Certifications","item":"https:\/\/data-flair.training\/blogs\/tag\/sas-foundation-tools-certifications\/"},{"@type":"ListItem","position":3,"name":"REST API in Power BI &#8211; Dataset, Import, Reports, Push Datasets"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/27360","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=27360"}],"version-history":[{"count":3,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/27360\/revisions"}],"predecessor-version":[{"id":32081,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/27360\/revisions\/32081"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/27376"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=27360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=27360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=27360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}