🚀 Think you’ve got what it takes for a career in Data? Find out in just one minute!

Take the test now!
Are you a company?
Book an appointment

Author: Melanie

SHAP: interpreting AI models

shap

The ability to understand and explain the decisions taken by Artificial Intelligence or Machine Learning models has become essential. These sophisticated technologies are increasingly being integrated into critical areas such as health, finance and security. Solutions like SHAP (SHapley Additive exPlanations) are booming. SHAP is inspired by the concepts of cooperative game theory, and offers […]

SMO (Social Media Optimisation): What is it? What is it used for?

SMO (Social Media Optimisation): What is it? What is it used for?

In today’s digital world, an online presence is essential if you want to make a name for yourself and win market share. Over the past fifteen years, social media have played a key role in developing online awareness. But to be visible, you need to adopt the right strategy. This is known as SMO. What […]

SEO (Search Engine Optimisation): What is it? What is it used for?

SEO, or Search Engine Optimization, is the practice of optimizing a website or online content to improve its visibility and ranking in search engine results pages (SERPs) for relevant keywords and phrases.

A successful business is very often a visible business. In the age of the Internet, this visibility is achieved through search engines such as Google, Bing and Yahoo. But competition there is fierce. To make your mark, it’s vital to adopt the right strategy, namely SEO. In this article, we’ll explain what SEO is all […]

Data Storage: Exploring GCP Firestore

Learn about Google Cloud Firestore and its versatile applications. Discover how Firestore, a flexible, scalable NoSQL document database, empowers developers to build powerful and reliable applications with real-time data synchronization and global scalability.

Whether you’re developing a web or mobile application, or any other IT infrastructure, the use of a database is more than essential. And in the age of Big Data, cloud-based databases are all the rage. Among the most popular is GCP Firestore. In this article, we introduce you to this Google cloud service, its use, […]

Bootstrap: What is it? How do you create your web page with it?

Learn all about Bootstrap, the popular front-end framework, and how to leverage its powerful features to create stunning and responsive web pages. Discover step-by-step instructions for implementing Bootstrap's pre-designed components, grid system, and CSS utilities to streamline your web development process.

Developing a website requires knowledge of HTML, CSS and JavaScript. You need programming and integration skills in each of these three languages to master the creation of web applications. There are collections of tools containing HTML and CSS code and JavaScript plugins to facilitate the development and integration of an application. Today, we’re going to […]

Cloud Architect training: how to become a certified professional?

Becoming a certified Cloud Architect involves gaining expertise in cloud computing technologies and obtaining certification from recognized organizations. Here's a general roadmap to becoming a certified Cloud Architect:

Cloud Architect training provides the skills needed to practise this essential profession for digital transformation, acting as a bridge between a company’s strategic vision and its technical implementation. Find out why and how to succeed in this dynamic, fast-growing field! Over the last few decades, the technological landscape has changed radically. The digital age has […]

Databricks on GCP: a powerful synergy

Databricks on Google Cloud Platform offers a powerful synergy that enables organizations to build scalable, flexible, and cost-effective

Databricks, originally founded by the creators of Apache Spark, is an open source technology for large-scale data processing. In the GCP (Google Cloud Platform) infrastructure, the combination of Databricks and the Google environment offers unrivalled flexibility, scale and processing power. What is Databricks? Databricks is a revolutionary unified data platform that has radically changed the […]

CPC (cost per click): What is it? What is it used for?

CPC, or Cost Per Click, is a digital advertising metric used to measure the cost incurred by an advertiser for each click on their advertisement. It is a common pricing model in online advertising platforms, where advertisers pay a predetermined fee each time a user clicks on their ad.

Whether for advertising on search engines or social networks, CPC (or cost per click) is one of the benchmark indicators. So what exactly is it? What is it used for? How can it be optimised? Find out the answers. What is CPC? CPC stands for cost per click. In other words, the cost charged to […]

CPA (cost per acquisition): What is it? What is it used for?

CPA (cost per acquisition): What is it? What is it used for?

While cost-per-click and cost-per-thousand impressions are very often used by digital marketing professionals, it is also possible to invoice on a CPA basis. What exactly is this? How is it calculated? What are the advantages and disadvantages? How can you optimise the cost per action? All the answers are in this article. Definition of the […]

CTR (click-through rate): What is it? What is it used for?

CTR, or Click-Through Rate, is a digital marketing metric used to measure the effectiveness of an online advertising campaign or link by calculating

One of the key indicators for web marketing professionals is the CTR (or click through rate). So what is it? How do you calculate it? And above all, how can it be optimised? We’ll answer all your questions. What is CTR? CTR is an anagram of the term “Click through rate”. CTR is a performance […]

ROAS (return on ad spend): What is ROAS? What is it used for?

Power BI REST API: what is it and how do you use it? April 25, 2024 - Reading Time: 7 minutes Business Intelligence Power BI Rest API With Power BI REST APIs can be used to perform integration, administration and governance tasks. In particular, they provide programmatic access to datasets or reports. Find out how you can use these tools to go beyond the limits of Microsoft's Business Intelligence platform! Microsoft’s Power BI platform offers a complete business intelligence solution. It enables data to be collected, analysed and displayed. In just a few years, this tool has simplified access to Business Intelligence thanks to its intuitive interface. It is now a benchmark in the BI market. One of the many strengths of Power BI is the ability to access datasets and reports via a REST API. Read on to find out how. 💡Related articles: Power BI Desktop download and installation guide I DataScientest Power BI Time Intelligence: Everything you need to know about these DAX functions Power BI Report Builder: What is it? How do I use it? Incremental Update Power BI: Microsoft’s Business Intelligence solution What is Power BI? Microsoft’s Power BI platform is a complete Business Intelligence solution, enabling companies to establish a data-driven culture within their organisations. Thanks to this tool, employees can access the benefits of self-service data analysis without having to call on IT teams. The various components of Power BI enable data to be collected from a wide range of sources, analysed and visualised, and dashboards and reports to be created. A wide variety of data sources are supported thanks to ready-to-use connectors. These range from locally-used software to third-party sources and cloud services. This platform offers a number of advantages. First and foremost, it is an intuitive and accessible tool, available on PC, mobile and as a cloud service. Its drag-and-drop interface makes it easy to generate customised reports. However, it is also possible to go into more detail on a visual to explore the data in greater depth. Natural language queries eliminate the need for complex query language. What is a Power BI REST API? An API is an Application Programming Interface. It is a type of software interface that enables two applications to communicate with each other. In simple terms, it is a way of transmitting and obtaining information without having to deal with the technical aspects. The acronym REST stands for “Representational State Transfer”. A REST API is therefore a representative state transfer programming interface. In short, it allows you to search for elements of a service by making a request. These APIs are designed to guide the development and design of architecture for the World Wide Web, and define a set of constraints for the behaviour of the architecture of a distributed system. They offer a flexible and lightweight way of integrating applications. Simply perform a search, and the results are returned from the service on which the request was made. A REST API is made up of several components. The “headers” are the authentication mode and the content types. The “method” is used to call a REST API. There are several, but the most common are POST and GET. The GET method is used to assemble information, while the POST method is used to send information to resources on the web. The “Endpoint” is the URL of the resource to which the requests are made. Finally, the “Data” or “Body” designates the textual data in JSON format to be sent to the resource. For a REST API to work properly, several design principles must be respected. Firstly, the server and client applications must be completely decoupled and independent of each other. On the client side, the only information available must be the URL of the requested resource. The server application must only transfer the requested data to the client via HTTP. Another feature: a REST API is Stateless. This means that each request must contain all the information required for processing, and that no server-side session is necessary. Storage of data linked to client requests is not authorised for the server. Resources must also be cached wherever possible on the server or client side. Server responses must also contain information indicating whether caching is permitted for the resource being delivered. The interface must be uniform, and all API requests for the same resource should be similar regardless of where the request originates. Finally, calls and responses must pass through different intermediate layers. In order to access the Power BI REST API securely, it is necessary to start with an embedded token request that enables APIs to be called and functions to be executed. This can be done using Postman. This free tool allows you to make POST or GET calls for different URLs and save the results in a collection. All you need to do is download it from its official site. What are the benefits of the Power BI REST API? Using a REST API on Power BI, it is possible to organise or integrate content and perform governance administration tasks. It enables custom applications to be built to deliver data to a Power BI dashboard using programmatic access to dashboard components such as datasets, tables or columns. It is possible to obtain or create datasets, obtain or update tables, add or delete rows, as well as perform group, import and dashboard operations. How do I configure a Power BI REST API connection? Using a REST API, it’s easy to connect a data source to Power BI. The first step is to register an application for Power BI, by going to the Developer Portal and logging in with your credentials. Once logged in, simply click on the ‘Next’ button to continue the integration process. To register the application, give it a name and choose its type: server-side or native. Enter a homepage and redirect URL, and define the API access permissions for the application. Give read access permissions for datasets, reports, workspaces and dashboards. Then click on the register button to start creating the application. Copy the key and the secret response to a secure location, as you will need them later. The second step in the Power BI REST API integration is to authorise the users of the application. This requires the Application ID and access token. The connection URL needs to be prepared, accepting various parameters such as Scope, State, ResponseMode, CLietnID, ResponseType and RedirectURL. Copy and paste the URL into your browser and press enter. Approve the user consent request, and the user will be redirected to the redirect URL specified in the API request. This request usually carries a code that can be used as an authentication method to call the APIs securely. If no web application is running on the web host, an error code will appear. In the “URL required” section, you will find a text. Copy it and store it safely. Once you have the code, the next step is to generate an access token. This requires an endpoint to be called using the POST method. The access_token is a value to be used when calling the Power BI REST API. Copy and store this value safely. You can now call the REST API and collect the details you need. Use the access token as an authorisation method in the header of a GET request. Scopes and Main Service of Power BI REST API To use the Power BI REST APIs, you need to register an Azure Active Directory (Azure AD) application on the Microsoft Azure cloud. The Azure AD application sets up permissions for Power BI REST resources, and allows access to the Power BI REST APIs. Once an Azure AD application has been registered, it is possible to authenticate using Microsoft endpoints or Azure AD. To add permissions (scopes) to an Azure AD application, simply open it on Azure, select API Permissions from the management menu, and choose “add a permission”. In the query API permissions window, choose Power BI Service. Select “Delegated permissions”, and choose the APIs for which you want to add permissions from the list. On the other hand, to remove scopes, open the application on Azure and choose “API permissions” from the management menu. Choose the context menu and click on the delete permission option. However, scopes are not required when using a “Principal Service”. This is an identity created within Azure to allow access to Azure resources including hosted applications, tools and services. Once a Master Service has been activated for Power BI, the application’s AD permissions no longer have any effect. Permissions are managed directly via the Power BI administration portal. 💡Related articles: DAX Power BI: all about the query programming language Dataflow Power BI: everything you need to know about the self-service ETL tool Power BI Direct Query: All you need to know about this data query method Power BI license: What does it cost? Power BI vs. Tableau: Two tools Excel vs. Power BI: What are the differences? Import data and update dashboards in Power BI REST API A REST API can also be used to import data into Power BI from other services. You can also automatically update a Power BI dashboard by scheduling a data refresh. From the Power BI for PC application, simply click on the ‘Get Data’ button. You can then choose the ‘Web’ option and provide the endpoint URL of the REST API from which you wish to extract the data. Imported data is generally in JSON format. It is therefore preferable to convert it into a table, so that you can then create models and visualisations from this data. To do this, right-click on the data in the Power Query editor and select the convert to table option. A button then allows you to extend the attributes of the JSON data, and choose which attributes to include in the data model. Once you have created visuals on a report using the imported data models, you can create a dashboard to share these visuals by publishing them on the online version of Power BI. There is also an option to schedule an automatic refresh of the dataset. On the online version, right-click on the dataset and choose the update schedule option. This feature enables Power BI to regularly collect new data from the REST API endpoint and update the visuals on the dashboard. How do I master Power BI? REST APIs are just one of the many facets of Power BI. To learn how to master this platform in its entirety, DataScientest is the place to be. Our Power BI training is divided into two parts: beginner and advanced. The first part lasts 24 hours spread over 3 days, and teaches you how to use tools such as DAX and Power Query to analyse data and create dashboards with Power BI. The second part lasts 14 hours over 2 days. It allows you to deepen your understanding of Power BI by discovering the subtleties of each service and the more complex concepts such as DataFlows and Incremental Refresh. Finally, the Complete Mastery course combines the two courses and covers 38 hours over 5 days. This course is designed to give you complete expertise in Power BI. As a Microsoft Learning Partner, DataScientest enables you to take the Microsoft PL-300 certification exam to become a Power BI Analyst Associate. All our teachers also have Microsoft Certified Trainer status. And don’t worry about funding: our government-recognised organisation is eligible for different funding options. There’s no time to lose in discovering DataScientest! Discover our Power BI training

To maximise their visibility and sales, many companies invest in advertising. But the cost of advertising is often considerable. And the return on investment isn’t always there. That’s precisely why it’s so important to measure ROAS. So what is it? How is it calculated? What’s the point of this method? Find out the answers. What […]

CRO (conversion rate optimisation): What is it? What is it used for?

CRO, or Conversion Rate Optimization, is a marketing strategy aimed at increasing the percentage of website visitors who take a desired action, such as making a purchase, signing up for a newslette

Whether for websites, sales pages or other landing pages, companies have every interest in optimising their conversion rate. To do this, they have a range of tools and methods at their disposal. This is known as CRO (Conversion Rate Optimisation). In this article, we explain what it’s for and how to set it up. What […]

Training platform
Want to follow the news of Datascientest?
Subscribe to our newsletter !
Sign up
© 2024 DataScientest - All rights reserved.