Power BI working area dynamic data backup system and device and storage medium

Abstract

The invention discloses a Power BI working area dynamic data backup system and device and a storage medium, the system comprises an interface processor and a backup scheduler, the interface processor is used for receiving a first selection signal and determining a target Power BI working area according to the first selection signal; and the backup scheduler is used for backing up the target Power BI working area when a trigger condition is met, so that automatic power BI working area dynamic data backup is realized, data management and recovery are performed on the power BI working area dynamic data, and data errors or missing are avoided.

Description

Technical Field

[0001] The present application relates to the field of data management technology, and in particular to a Power BI workspace dynamic data backup system, device and storage medium. Background Art

[0002] Power BI (power business intelligence) is a collection of software services, applications, and connectors that work together to transform relevant data sources into coherent, visually realistic, interactive insights. Whether the user's data is a simple Excel spreadsheet or a collection of cloud-based and local hybrid data warehouses, Power BI allows users to easily connect to data sources, intuitively see (or discover) important content, and share it with anyone they want. As a platform for collaboration with colleagues, the Power BI workspace allows users to create and manage dashboards, reports, semantic models, and paginated reports, and is widely used in enterprise data analysis and decision support scenarios. However, due to the dynamic changes and frequent updates of data in the Power BI workspace, it is difficult to achieve efficient backup and recovery of related data management methods, which can easily lead to data errors or loss, affecting business continuity and data reliability.

[0003] There is currently no effective solution to the problem of data errors or missing in the dynamic data management process of Power BI workspaces in related technologies. Summary of the invention

[0004] According to various embodiments of the present application, a Power BI workspace dynamic data backup system, system, device and storage medium are provided.

[0005] In a first aspect, the present application provides a Power BI workspace dynamic data backup system, including an interface processor and a backup scheduler.

[0006] The interface processor is used to receive a first selection signal and determine a target PowerBI workspace according to the first selection signal;

[0007] The backup scheduler is used to back up the target Power BI workspace when a trigger condition is met.

[0008] In some of the embodiments, the Power BI workspace dynamic data backup system also includes a report selector for receiving a second selection signal and determining a target report corresponding to a target Power BI workspace according to the second selection signal; the backup scheduler is also used to back up the target report when the trigger condition is met.

[0009] In some embodiments, the Power BI workspace dynamic data backup system further includes a timing controller or an event trigger.

[0010] The timing controller is used to obtain the current time, and when the current time reaches the preset time, output a signal to start the backup to the backup scheduler;

[0011] The event trigger is used to detect a target event, and when the target event occurs, outputs a trigger signal to the backup scheduler to start the backup.

[0012] In some of the embodiments, the Power BI workspace dynamic data backup system further includes an authentication processor, which is used to receive credentials and request an access token from Azure Active Directory based on the credentials, and activate the backup scheduler after receiving the access token.

[0013] In some of these embodiments, the authentication processor includes a session validator for continuously checking the validity of the access token and refreshing the access token when a preset condition is met.

[0014] In some of the embodiments, the Power BI workspace dynamic data backup system further includes a data export processor for interfacing with Power BI via a REST API to export the target report.

[0015] In some embodiments, the Power BI workspace dynamic data backup system further includes an authentication processor, the authentication processor is used to receive credentials, and request an access token from Azure Active Directory based on the credentials, and after receiving the access token, activate the backup scheduler;

[0016] The data export processor is also used to interface with Power BI through an API communication interface, and export the target report after completing identity authentication based on the access token.

[0017] In some of the embodiments, the Power BI workspace dynamic data backup system also includes a REST API integration for communicating with the Power BI service.

[0018] In some of the embodiments, the Power BI workspace dynamic data backup system further includes a file management system for saving the backup data of the target Power BI workspace and the target report into a structured directory.

[0019] In a second aspect, the present application also provides a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, the Power BI workspace dynamic data backup system as described in the first aspect above is implemented.

[0020] In a third aspect, the present application further provides a storage medium having a computer program stored thereon, which, when executed by a processor, implements the Power BI workspace dynamic data backup system as described in the first aspect above.

[0021] Compared with the related art, the Power BI workspace dynamic data backup system provided in this application is used to automate the backup of the dynamic data of the Power BI workspace, so as to manage and recover the dynamic data of the Power BI workspace, and solve the problem of data errors or missing in the dynamic data in the Power BI workspace in the related art.

[0022] The details of one or more embodiments of the present application are set forth in the following drawings and description. Other features, objects, and advantages of the present application will become apparent from the description, drawings, and claims. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the conventional technology, the drawings required for use in the embodiments or the conventional technology descriptions are briefly introduced below. Obviously, the drawings described below are merely embodiments of the present application, and ordinary technicians in this field can obtain other drawings based on the disclosed drawings without paying any creative work.

[0024] Figure 1 This is a hardware structure block diagram of a terminal using a Power BI workspace dynamic data backup system according to an embodiment of the present application.

[0025] Figure 2 This is a structural diagram of a Power BI workspace dynamic data backup system according to an embodiment of the present application.

[0026] Figure 3 This is a structural diagram of a Power BI workspace dynamic data backup system according to an embodiment of the present application.

[0027] Figure 4 This is a structural diagram of a Power BI workspace dynamic data backup system according to an embodiment of the present application.

[0028] Figure 5 This is a structural diagram of a Power BI workspace dynamic data backup system according to an embodiment of the present application.

[0029] Figure 6 This is a structural diagram of a Power BI workspace dynamic data backup system according to an embodiment of the present application.

[0030] Figure 7 This is a structural diagram of a Power BI workspace dynamic data backup system according to an embodiment of the present application.

[0031] Figure 8 This is a structural diagram of a Power BI workspace dynamic data backup system according to an embodiment of the present application.

[0032] Fig. 9 This is a structural diagram of a Power BI workspace dynamic data backup system according to an embodiment of the present application.

[0033] Fig.10 This is a structural diagram of a computer device according to one embodiment of the present application. DETAILED DESCRIPTION

[0034] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

[0035] Unless otherwise defined, the technical terms or scientific terms involved in this application shall have the general meaning understood by people with ordinary skills in the technical field to which this application belongs. The words "one", "a", "a", "the", "these" and the like in this application do not indicate a quantitative limitation, and they can be singular or plural. The terms "include", "comprise", "have" and any variants thereof involved in this application are intended to cover non-exclusive inclusions; for example, a process, method, product or device comprising a series of steps or modules (units) is not limited to the listed steps or modules (units), but may include unlisted steps or modules (units), or may include other steps or modules (units) inherent to these processes, methods, products or devices. The words "connect", "connected", "coupled" and the like involved in this application are not limited to physical or mechanical connections, but may include electrical connections, whether direct or indirect. The "multiple" involved in this application refers to two or more. "And / or" describes the association relationship of associated objects, indicating that there can be three relationships, for example, "A and / or B" can mean: A exists alone, A and B exist at the same time, and B exists alone. Generally, the character " / " indicates that the objects associated with each other are in an "or" relationship. The terms "first", "second", "third", etc. in this application are only used to distinguish similar objects and do not represent a specific ordering of the objects.

[0036] The system embodiments provided in this application can be executed in a terminal, a computer or a similar computing device. For example, running on a terminal, Figure 1 This is a hardware structure diagram of the terminal of this application. Figure 1 As shown, the terminal may include one or more ( Figure 1 Only one is shown in the figure) processor 102 and memory 104 for storing data, wherein processor 102 may include but is not limited to a processing device such as a microprocessor MCU or a programmable logic device FPGA. The above terminal may also include a transmission device 106 and an input and output device 108 for communication functions. It can be understood by those skilled in the art that Figure 1 The structure shown is only for illustration and does not limit the structure of the above terminal. Figure 1 More or fewer components as shown, or with Figure 1 Different configurations shown.

[0037] The memory 104 can be used to store computer programs, for example, software programs and modules of application software, such as the computer program corresponding to the Power BI workspace dynamic data backup system in this embodiment. The processor 102 executes various functional applications and data processing by running the computer program stored in the memory 104, that is, the above-mentioned Power BI workspace dynamic data backup system is realized. The memory 104 may include a high-speed random access memory, and may also include a non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some instances, the memory 104 may further include a memory remotely arranged relative to the processor 102, and these remote memories can be connected to the terminal via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and a combination thereof.

[0038] The transmission device 106 is used to receive or send data via a network. The above network includes a wireless network provided by the communication provider of the terminal. In one example, the transmission device 106 includes a network adapter (Network Interface Controller, referred to as NIC), which can be connected to other network devices through a base station so as to communicate with the Internet. In one example, the transmission device 106 can be a radio frequency (Radio Frequency, referred to as RF) module, which is used to communicate with the Internet wirelessly.

[0039] This application provides a Power BI workspace dynamic data backup system. Figure 2 is a structural diagram of a Power BI workspace dynamic data backup system according to an embodiment of the present application. Figure 2 As shown, the Power BI workspace dynamic data backup system includes an interface processor 210 and a backup scheduler 220 .

[0040] The interface processor 210 is used to receive a first selection signal and determine a target Power BI workspace according to the first selection signal.

[0041] The backup scheduler 220 is used to back up the target Power BI workspace when a trigger condition is met.

[0042] In this embodiment, the Power BI workspace dynamic data backup system includes an interface processor 210 and a backup scheduler 220. The interface processor 210 can receive a first selection signal and determine a target Power BI workspace according to the first selection signal. The target Power BI workspace is the Power BI workspace that needs to be backed up. When the trigger condition is met, the backup scheduler 220 backs up the target Power BI workspace, thereby realizing automatic backup of dynamic data in the Power BI workspace and solving the problem of data errors or missing in dynamic data in the Power BI workspace in related technologies.

[0043] Specifically, the interface processor 210 can interact with the user through the user interface, such as receiving the user's first selection signal through the user interface to determine the target Power BI workspace. The backup scheduler 220 is an automatic controller with a backup function. When the trigger condition is met, the target Power BI workspace selected by the user can be backed up. The trigger condition can be a preset time, a specific event or a system status.

[0044] In some embodiments, Figure 3 As shown, the Power BI workspace dynamic data backup system also includes a report selector 230, which is used to receive a second selection signal and determine a target report corresponding to the target Power BI workspace according to the second selection signal; the backup scheduler 220 is also used to back up the target report when the trigger condition is met.

[0045] In this embodiment, the Power BI workspace dynamic data backup system is also provided with a report selector 230, which can receive a second selection signal and determine the target report according to the second selection signal. When the trigger condition is met, the backup scheduler 220 backs up the target report corresponding to the target Power BI workspace, thereby realizing the automatic backup of the dynamic data of the Power BI workspace.

[0046] Specifically, the report selector 230 can interact with the user through the user interface, such as receiving the user's second selection signal through the user interface to determine the target report corresponding to the target Power BI workspace. When the trigger conditions are met, the backup scheduler 220 can simultaneously back up the target Power BI workspace and target report selected by the user.

[0047] It should be noted that the user interface can be a part of the Power BI workspace dynamic data backup system, and the interface processor 210, the backup scheduler 220 and the report selector 230 can all be implemented by software.

[0048] Further, the user interface is the component where the user interacts with the software to specify the Power BI workspaces and reports to be backed up. The user interface reads the user's input, which defines the scope of the backup process. The user interface includes a command line prompt or a configuration file. The user can list the names of workspaces and reports in the user interface to achieve customized backup operations.

[0049] The user interface is an important component in the backup system that enables users to interact with the backup system. The user interface includes a menu-driven or command-line interface that prompts the user to select a target Power BI workspace and a target report. The user interface has a workspace selection menu that lists all available workspaces retrieved through the Power BI API, and a report selector that allows users to specify reports within the selected workspace. This user interface can also have a configuration loader for applying user-defined backup operation settings, such as backup frequency and the target directory for the backup, and an input validation system that can be used to check for errors or inconsistencies in user input to ensure the correctness of user input.

[0050] The user interface may include a graphical user interface (GUI) to facilitate intuitive interaction for users who do not want to use a command line interface. Functionally, the graphical user interface may provide drag-and-drop functionality for selecting reports, remember user preferences based on configuration file settings, and provide advanced filtering options to help users select reports. The configuration loader may also be designed to read configurations from a web-based form or cloud-based configuration service, allowing users to remotely manage their backup settings.

[0051] In some embodiments, Figure 4 As shown, the Power BI workspace dynamic data backup system also includes a timing controller 240 or an event trigger 250.

[0052] The timing controller 240 is used to obtain the current time, and when the current time reaches the preset time, output a signal to start the backup to the backup scheduler 220;

[0053] The event trigger 250 is used to detect a target event, and when the target event occurs, outputs a trigger signal to the backup scheduler 220 to start backup.

[0054] In this embodiment, the backup scheduler 220 can implement the backup operation through a variety of automated trigger conditions, including preset time, specific events or system status. The timing controller 240 can automatically start the backup at a preset time, and the event trigger 250 can trigger the backup operation when a specific event (such as data update, system abnormality) is detected. This application significantly improves the backup efficiency and intelligence level through a variety of automated trigger mechanisms, reduces manual intervention, and improves the automation of data management.

[0055] Specifically, the backup scheduler 220, the timing controller 240 and the event trigger 250 can be implemented in Python. The backup scheduler 220 can be a time-based automatic controller that triggers the backup process at a user-defined interval. The backup scheduler 220 can utilize integration with the system task scheduler or utilize a timing loop (timing controller 240) in a Python script to allow backup to be automatically performed at a specific time without manual intervention, ensuring that the backup is consistently executed according to the schedule set by the user.

[0056] The backup scheduler 220 may be an automated processor responsible for initiating the backup process at predetermined intervals. The backup scheduler 220 is integrated with the system's task scheduler, allowing backups to be performed without manual initiation. The backup scheduler 220 may include an interactive interface for setting and adjusting the time of the backup, providing the user with flexibility to determine the backup schedule based on demand.

[0057] The backup scheduler 220 may be integrated with the event trigger 250 to allow backup to be performed under specific target events. The backup scheduler 220 may include a scheduler interface for setting and adjusting target events.

[0058] Furthermore, the backup scheduler 220 can introduce and execute machine learning algorithms or artificial intelligence to intelligently predict and recommend backup times based on the system's usage patterns and load conditions. By analyzing historical data and system status, the machine learning algorithm can dynamically adjust the backup plan to avoid backup operations when the system is highly loaded, thereby optimizing resource utilization, thereby solving the problem of resource waste or load imbalance that may be caused by fixed-time backup, and improving the system's intelligence level and the efficiency of backup task execution.

[0059] In some embodiments, Figure 5 As shown, the Power BI workspace dynamic data backup system also includes an authentication processor 260, which is used to receive credentials and request an access token from Azure Active Directory based on the credentials, and activate the backup scheduler 220 after receiving the access token.

[0060] In this embodiment, the authentication processor 260 is mainly used to authenticate the user and use the credentials to request an access token from Azure Active Directory, that is, to authenticate the user. After the authentication is successful, Azure Active Directory will send an access token to the authentication processor 260, and activate the backup scheduler 220 based on the access token. The backup scheduler 220 can perform backup operations.

[0061] It should be noted that Azure Active Directory is a cloud-based identity and access management (IAM) service that is mainly used to manage user identities and their access rights to resources, including local and cloud applications. Azure Active Directory can be regarded as a cloud identity service that manages authentication between users and systems to ensure that the right people access the right resources.

[0062] In some embodiments, the authentication processor 260 includes a session validator for continuously checking the validity of the access token and refreshing the access token when a preset condition is met.

[0063] In this embodiment, the authentication processor 260 may be equipped with a session validator to continuously check the validity of the access token to ensure that the service is not interrupted during the user session.

[0064] Specifically, the authentication processor 260 and the session validator can be applied in Python. The authentication processor 260 can be a security component for managing user access to the Power BI service. The authentication processor 260 can use the Python library 'adal' (Automatic Database Access Layer) to interact with Azure Active Directory to facilitate the secure generation of access tokens. The authentication processor 260 obtains the credentials entered by the user, uses the credentials to request an access token from Azure Active Directory, and processes the token storage during the session for subsequent API calls. The authentication processor 260 can perform the authentication process, error handling for login failures, and secure storage of access tokens during the session.

[0065] Furthermore, the authentication processor 260 may include a token request processor and an authentication error processor, wherein the token request processor is used to manage the operation of requesting an access token from Azure Active Directory, and the authentication error processor is used to process and respond to authentication failures.

[0066] The authentication processor 260 acts as a portal for secure interaction with the Power BI API. The authentication processor 260 can be built with the Python library 'adal' to initiate a secure connection with Azure Active Directory (AD). The authentication processor 260 includes a credential input interface where the user enters their credentials, which are then encrypted and transmitted to AD to generate an access token. The access token received by the authentication processor 260 is temporarily stored in the access token storage, which protects the access token from unauthorized access and is provided for use in subsequent API requests issued by the system. Error handling for failed logins is used to notify the user and safely handle authentication failures due to incorrect credentials or other errors. In addition, the session validator continuously checks the validity of the access token and refreshes the access token when the preset conditions are met to ensure uninterrupted service during the user session. The preset conditions can be set according to the actual needs of the user or system requirements.

[0067] Furthermore, the authentication processor 260 can support multiple authentication protocols (such as OAuth2 or OpenIDConnect) and can be configured according to security requirements and user preferences. Functionally, the authentication processor 260 can allow multi-factor authentication, including password, SMS, and verification code login, providing an additional layer of security. In addition, the authentication processor 260 also supports biometric authentication methods, such as iris, fingerprint, face, finger vein, joint pattern, etc. By integrating multi-factor authentication and biometric verification, the security of the data backup system can be significantly improved, ensuring the legitimacy of the backup operation and access security, which is suitable for scenarios with high security requirements.

[0068] In some embodiments, Figure 6 As shown, the Power BI workspace dynamic data backup system also includes a data export processor 270, which is used to interface with Power BI through a REST API to export the target report.

[0069] In this embodiment, the Power BI workspace dynamic data backup system also includes a data export processor 270. When performing backup, the data export processor 270 can export and save the target report corresponding to the target Power BI workspace.

[0070] Specifically, the data export processor 270 is responsible for retrieving and saving Power BI report data. The data export processor 270 mainly involves REST API (Representational State TransferApplication Programming Interface) calls issued to the Power BI service, which request the export of report data. The data export processor 270 processes the API response, extracts the binary data and writes it to the appropriate file format, ensuring the integrity and completeness of the data during the export process.

[0071] The data export processor 270 interfaces with the Power BI service through a REST API to export reports. The data export processor 270 converts the Power BI report into a downloadable format, handles data retrieval, and ensures integrity during transmission to local storage.

[0072] The data export processor 270 can support the export of multiple data formats, including but not limited to CSV, Excel, PDF and other formats, to meet different business needs. At the same time, the data export processor 270 can compress the exported data to reduce the storage space occupied. Through parallel processing technology, the data export processor 270 can export multiple reports at the same time, greatly improving the data export speed and backup efficiency. The data export processor of the present application combines multi-format support, data compression and parallel processing, which is suitable for the efficient backup needs of large-scale dynamic data and improves the performance and practicality of the system.

[0073] Furthermore, the data export processor 270 includes a data retrieval processor and an export file writer, wherein the data retrieval processor is used to manage the downloading of binary data, and the export file writer is used to write the retrieved backup data into a specified file format.

[0074] Furthermore, the data export processor 270 can perform incremental backup, exporting only newly added or changed data, and not exporting the backed up data repeatedly. This incremental backup method effectively reduces the amount of data transmission and storage space occupied during each backup operation, improves backup efficiency, solves the problem of redundant data transmission in related backup systems, reduces storage costs, and improves the utilization of system resources.

[0075] In some embodiments, the data export processor 270 may be triggered by the event trigger 250 described above, thereby performing a data export operation.

[0076] In some embodiments, Figure 7As shown, the Power BI workspace dynamic data backup system further includes an authentication processor 260, which is used to receive credentials and request an access token from Azure Active Directory according to the credentials, and activate the backup scheduler 220 after receiving the access token;

[0077] The data export processor 270 is also used to interface with Power BI through an API communication interface, and export the target report after completing identity authentication based on the access token.

[0078] In this embodiment, the identity authentication processor 260 can obtain an access token, and the data export processor 270 can use the access token to authenticate the API request through the API communication interface before exporting the target report to ensure the legitimacy of the target report export.

[0079] In some embodiments, Figure 8 As shown, the Power BI workspace dynamic data backup system also includes a REST API integration 280 for communicating with the Power BI service.

[0080] In this embodiment, the REST API integration 280 is a set of functions that allow the software to communicate with the Power BI service. The REST API integration 280 includes constructing HTTP requests, processing authentication headers, sending requests to the Power BI API endpoint, and processing responses. The REST API integration acts as a communication bridge between the local backup system and the remote Power BI service, facilitating data transfer and command execution.

[0081] Specifically, the REST API integration 280 consists of a set of function tasks, which are responsible for managing the communication between the Power BI workspace dynamic data backup system and the Power BI service, and handling authentication, data request, and response processing.

[0082] Furthermore, the REST API integration 280 can be integrated with other APIs to improve the speed and data efficiency of network problem error handling and optimization, and adapt to a wider range of data management scenarios.

[0083] Furthermore, the REST API integration 280 includes an endpoint parser, a header constructor, and a response processor, wherein the endpoint parser is used to identify the correct API endpoint for the request, the header constructor is used to prepare an authorization header for the API call, and the response processor is used to interpret the API response and handle errors.

[0084] In some embodiments, Fig. 9As shown, the Power BI workspace dynamic data backup system also includes a file management system 290 for saving the backup data of the target Power BI workspace and the target report into a structured directory.

[0085] In this embodiment, the file management system 290 can organize and manage the backup data into structured directories. The file management system 290 consists of a series of functions that check whether the target directory exists, create a new directory if necessary, and manage the naming and saving of backup files. The file management system 290 ensures that the exported data is stored in an organized manner for easy retrieval and management.

[0086] The file management system 290 organizes the exported reports into structured directories on the user's system. The file management system 290 automatically creates folders and manages file naming based on user configuration or default settings.

[0087] Furthermore, the file management system 290 can save the exported backup data into a structured directory, automatically create folders and name files according to user configuration or default settings, and implement structured storage of backup data, which is convenient for data retrieval and management. In addition, the file management system 290 can store backup data in the cloud through cloud storage integration, and has the function of automatically cleaning up outdated backups to optimize storage space utilization. To ensure data security, the file management system 290 encrypts the saved backup files to provide additional security. This application improves the security and manageability of backup data through structured storage and secure encryption of the file management system, and is suitable for enterprise-level and cloud storage scenarios.

[0088] Furthermore, the file management system 290 includes a directory path parser, a directory creation tool and a file naming processor, wherein the target path parser is used to determine and set the path of the backup storage, the directory creation tool is used to generate the backup directory structure, and the file naming processor is used to assign names to the backup files according to user input.

[0089] In a specific embodiment, the specific working principle of the Power BI workspace dynamic data backup system is as follows:

[0090] The credential input interface of the authentication processor 260 provides the user credentials to the token request processor, which communicates with Azure Active Directory to obtain an access token. The access token is then securely stored by the access token store and can be used by the API communication interface in the data export processor for authentication of API requests. The session validator ensures that the access token remains valid during the user session and works in conjunction with the authentication error handler to handle any authentication issues that arise.

[0091] The user interface's workspace selection menu and report selector 230 allow the user to specify backup parameters, which are processed by the configuration loader and validated by the input validation system. These selections determine the operation of the backup scheduler 220, which uses a timing controller 240 and event triggers 250 to initiate backups at user-defined times.

[0092] The API communication interface of the data export processor 270 coordinates the data retrieval using the access token, and the data retrieval processor processes the incoming data stream. The export file writer creates the output files and hands them to the file management system's directory path resolver and directory creation tool, which will organize the saved backups in a structured directory of the file naming processor.

[0093] The Power BI workspace dynamic data backup system automates the backup process of Power BI reports, ensuring user customization, security, and efficient data management.

[0094] In some embodiments, it starts with the user providing their credentials through the credential input interface of the authentication processor 260. These credentials are securely transmitted to Azure Active Directory by the token request processor, which returns an access token that is then saved by the access token store. The session validator continuously checks the validity of the token, and the authentication error processor handles any authentication errors that occur.

[0095] Once authentication is successful, the user interface allows the user to select Power BI workspaces and reports to be backed up via a workspace selection menu and report selector. User input is processed by the configuration loader and validated by the input validation system to ensure it meets the standards set by the backup process.

[0096] The backup scheduler 220 uses the timing controller 240 to determine when to start the backup after receiving the user-defined parameters. At the scheduled time, the event trigger 250 activates the data export processor 270, which sends a request to Power BI using the API communication interface. The data retrieval processor manages the incoming backup data, and the export file writer writes this backup data into the specified file format to ensure the integrity and comprehensiveness of the backup.

[0097] Meanwhile, the file management system 290 uses the directory creation tool to create a structured directory if the target directory does not exist. The directory path parser sets the path for the backup, and the file naming processor assigns an appropriate name to each backup file according to user settings or default parameters.

[0098] Finally, the REST API integration 280 ensures that all communications between the local backup system and the remote Power BI service occur accurately and securely. The endpoint resolver directs requests to the correct Power BI API endpoint, the header constructor prepares the authorization header, and the response handler manages the API response, including any data or network errors.

[0099] The operating result of the Power BI workspace dynamic data backup system is a user-driven, automated and secure Power BI backup. This application achieves secure and efficient backup and management of dynamic data in the Power BI workspace through a variety of automated trigger mechanisms, incremental backup, machine learning optimization, multi-factor authentication, efficient data export and secure file management. The system is managed through a Python script mechanism and can be integrated into any type of cloud environment for full automation. This application effectively solves the problems of data loss, low backup efficiency and insufficient security in related technologies, improves the reliability and recoverability of data management, and is suitable for the data backup needs of various enterprises and organizations.

[0100] It should be understood by those skilled in the art that the above-mentioned components or steps of the present application can be implemented with a general computing device, they can be concentrated on a single computing device, or distributed on a network composed of multiple computing devices, optionally, they can be implemented with program codes executable by a computing device, so that they can be stored in a storage device and executed by the computing device, and in some cases, the steps shown or described can be executed in an order different from that herein, or they can be made into modules respectively, or multiple components therein can be made into a single module for implementation. Thus, the present application is not limited to any specific combination of hardware and software.

[0101] The present application also provides a computer device 300, which may be a server. Fig.10 is a structural diagram of a computer device according to an embodiment of the present application. Fig.10 As shown, the computer device 300 includes a processor 31, a memory and a network interface 33 connected via a system bus. The processor 31 of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a storage medium 321 and an internal memory 322. The storage medium 321 stores an operating system, a computer program and a database. The internal memory 322 provides an environment for the operation of the operating system and the computer program in the storage medium 321. The network interface 33 of the computer device is used to communicate with an external terminal via a network connection. When the computer program is executed by the processor 31, a Power BI workspace dynamic data backup system is implemented.

[0102] Those skilled in the art will understand that Fig.10 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0103] In addition, in combination with the Power BI workspace dynamic data backup system in the above embodiment, the present application embodiment can provide a storage medium 321 for implementation. The storage medium 321 stores a computer program, and when the computer program is executed by the processor, any of the Power BI workspace dynamic data backup systems in the above embodiment is implemented.

[0104] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application can include non-volatile and / or volatile memory. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM) or flash memory. Volatile memory can include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synch link) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).

[0105] The technical features of the above-described embodiments may be arbitrarily combined. To make the description concise, not all possible combinations of the technical features in the above-described embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0106] The above-described embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be construed as limiting the scope of the patent application. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the patent application shall be subject to the attached claims.

Claims

1. A Power BI workspace dynamic data backup system, characterized in that: The system includes an interface processor and a backup scheduler. The interface processor is used to receive a first selection signal and determine a target Power BI workspace according to the first selection signal; The backup scheduler is used to back up the target Power BI workspace when a trigger condition is met.

2. The Power BI workspace dynamic data backup system according to claim 1, characterized in that: The system further includes a report selector, configured to receive a second selection signal and determine a target report corresponding to a target Power BI workspace according to the second selection signal; The backup scheduler is further configured to back up the target report when the trigger condition is met.

3. The Power BI workspace dynamic data backup system according to claim 1, characterized in that: The system also includes a timing controller or an event trigger, The timing controller is used to obtain the current time, and when the current time reaches the preset time, output a signal to start the backup to the backup scheduler; The event trigger is used to detect a target event, and when the target event occurs, outputs a trigger signal to the backup scheduler to start the backup.

4. The Power BI workspace dynamic data backup system according to claim 1, characterized in that: The system also includes an authentication processor, which is used to receive credentials and request an access token from Azure Active Directory based on the credentials, and activate the backup scheduler after receiving the access token.

5. The Power BI workspace dynamic data backup system according to claim 4, characterized in that: The authentication processor includes a session validator for continuously checking the validity of the access token and refreshing the access token when a preset condition is met.

6. The Power BI workspace dynamic data backup system according to claim 2, characterized in that: The system also includes a data export processor, which is used to interface with Power BI through a REST API to export the target report.

7. The Power BI workspace dynamic data backup system according to claim 6, characterized in that: The system further includes an authentication processor, the authentication processor being used to receive credentials, and request an access token from Azure Active Directory according to the credentials, and activate the backup scheduler after receiving the access token; The data export processor is also used to interface with Power BI through an API communication interface, and export the target report after completing identity authentication based on the access token.

8. The Power BI workspace dynamic data backup system according to any one of claims 1 to 7, characterized in that: The system also includes REST API integration for communicating with the Power BI service.

9. A computer device comprising a memory and a processor, characterized in that: A computer program is stored in the memory, and the processor is configured to run the computer program to implement the PowerBI workspace dynamic data backup system according to any one of claims 1 to 8.

10. A storage medium, characterized in that: The storage medium stores a computer program, wherein the computer program is configured to implement the Power BI workspace dynamic data backup system according to any one of claims 1 to 8 when running.

Images