Refresh Dataset

Refreshes a Power BI dataset for a specific customer and firm.

This endpoint decodes the provided customer key and report code, retrieves relevant customer and workspace details, and triggers a dataset refresh in Power BI using the specified report code.

Args: request (Request): The HTTP request object. customer_key (Annotated[Union[str], Header]): A base64 encoded string containing 'lscode' and 'firmcode'. report_code (Annotated[Union[str], Header]): A base64 encoded report code. db (Session): The database session dependency.

Returns: JSONResponse: A response indicating the success or failure of the dataset refresh operation. It returns a success message if the refresh request is accepted by Power BI, otherwise an error message.

Raises: HTTPException: If settings could not be retrieved, customer or firm details are not found. JSONResponse: For any other exceptions during the process with a 500 status code.