Updating Schedule refresh for Power BI Report
Hi, As we know, Schedule refresh for Power BI report could be set manually on the UI. If we are trying to automate the setup of schedule refresh on a report instead of manually entering it, what are the optins we have - 1) Can the meta data tables ( Catalog, Subscriptions, Schedule, ReportSchedule) be used to stage entries into these tables and the schedule refresh shows up on the UI fo the report? 2) Any REST API code that could be used in a power shell script to place/update the schedule information on the report? Was able to extract Schedule from a Power BI report on Test report server to a JSOn file. Now need this information to be read from JSON file and updated to the report on Prod report sever? - REST API can do it? 3) If first and second options are not feasible, what other options are available? Also, why does this mesage popup under "Schedule Refresh" section ?
How to Add/change Deployment Pipeline's Admin in Power BI if not have access due to limitation
Quick Info : We have “Deployment Pipelines” in PowerBI which is the best way to use Workspace and content of power bi as Test Dev and PROD. More Info: https://docs.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-overview Currently, Deployment Pipeline has a Limitation where you cannot add/change the Pipeline assigned to the workspace if the user has not been given the rights on the pipeline. You should have Administrator Rights to run the Rest API for that workspace and azure directory ( Basically a Power BI Admin) Problem : Someone assigned the Workspace to his/her pipeline and left the organization. Did not add any other user/group to access the pipeline as per the recommendations. There is no way you can Assign yourself or your group to Pipeline and fix it.
Power BI Api to get parent dataset id by report id
If I have a report which is getting data from a dataset 1 which itself is getting data from another dataset 2, how to get dataset 2 id through report id as we can only know id of dataset 1, using api getDatasets(group id, report id). Till now, I'm using an approach not very performant, which is like once I get datasource for dataset 1, I compare datasource name with all datasets database connection names, to filter out parent datasets. As you can see in above, each time a call to get all datasets is time consuming. Is there any better way to do this using either one or multiple api calls?PowerBI - CICD using Azure DevOps
Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end-users to create their own reports and dashboards. Currently, there is no direct way of Implementing CICD in PowerBI. Using the Publish menu from the PowerBI Desktop is the easiest way to deploy/publish a report as of now. In this article, we are going to see how we can implement source control and CICD for PowerBI using Azure DevOps.Power BI Dev Camp - Developer Deep Dive into Row Level Security (RLS) | Jan. 27th 2022, 11am PDT
We have very exciting Power BI Dev Camp session this month covering Row Level Security. Please join us at Thursday, Janauary 27th at 2:00 PM EST/11:00AM PDT to learn the ins and outs of working with Row Level Security when building custom data analytics solutions for Power BI.Power BI Dev Camp: Oct. 28th 11a PST | Learn ALM in Power BI with Deployment Pipelines
The October Power BI Dev Camp session will teach campers how to use deployment pipelines for managing the application lifecycle of datasets and reports and for enabling CI/CD in a Power BI environment. The session explains how deployment pipelines are configured to create dedicated workspaces for developing and testing Power BI artifacts including datasets, reports, dashboards and dataflows.Power BI Dev Camp: June 24th | 11a PDT- Developing with the App-Owns-Data Starter Kit
Next week's Power BI Dev Camp session on Thursday, June 24 will introduce campers to the App-Owns-Data Starter Kit which is a sample solution for developers built using .NET 5 to provide guidance for organizations and ISVs who are using App-Owns-Data embedding with Power BI in a multi-tenant environment. If you are planning to use Power BI embedding to reach customers and other types of external users, the App-Owns-Data Starter kit provides the fastest way to stand up a custom application which embraces best practices for tenant provisioning, user authorization and activity monitoring.Power BI Dev Camp: Learn Advanced Dataset Programming with Power BI April 29th at 2P PST
Learn advanced dataset programming using both the Power BI REST API and the Tabular Object Model (TOM). In this Power BI Dev Camp session, campers will learn how to create and clone datasets as well as how to extend the data model for a dataset by adding tables, columns, measures, hierarchies and table relationships. This session will also cover the how to automate patching datasource credentials and running dataset refresh operations.Power BI Dev Camp -Session 5: December 17th - Learn About Developing for Power BI with React.js
Step up your game as a Power BI developer by learning how to develop single page applications (SPAs) to embed Power BI reports and dashboards using the ever-popular React.js library. If you're able to attend the December session of Power BI Dev Camp on Thursday, December 17th, you'll learn how to design and develop SPA applications using React components to handle routing, navigation and Power BI embedding.Power BI Dev Camp - update on Deep Dive for Power BI JavaScript API + Session 4 info on 11/19
It's exciting. We're starting to build up some momentum with our monthly Power BI Dev Camp sessions. Last week I presented our third session titled Deep Dive into the Power BI JavaScript API. This blog post provides links to the session slides and sample projects. It also provides information about our next Power BI Dev Camp session in November on the Tabular Object Model and the XMLA endpoint.
