1. Asked: July 7, 2023In:

    Need to convert Date Time into Time Zone Offset format in Power BI.

    Adithya Pundit
    This answer was edited.

    DateTime.ToText is the solution for this. 400 request is client side issue. Check your connectivity.

    DateTime.ToText is the solution for this. 400 request is client side issue. Check your connectivity.

    See less
    • 0
  2. Asked: July 7, 2023In:

    Numpy not working with for loop and .loc function.

    Peggy Professional
    This answer was edited.

    Remove 'apply' and try using np.floor() directly: np.floor(f1.loc[today,'QuantityNotRounded'])

    Remove ‘apply’ and try using np.floor() directly:

    np.floor(f1.loc[today,'QuantityNotRounded'])
    See less
    • 0
  3. Asked: July 7, 2023In:

    What are the advantages of using the Azure pipeline?

    dishach Explainer

    Advantages of using Azure DevOps pipeline: Continuous integration and delivery (CI/CD) Deployment to multiple environments Secured Cross-platform support Collaboration

    Advantages of using Azure DevOps pipeline:

    • Continuous integration and delivery (CI/CD)
    • Deployment to multiple environments
    • Secured
    • Cross-platform support
    • Collaboration
    See less
    • 0
  4. Asked: July 7, 2023In:

    How to implement cross join in power BI using power query?

    Adithya Pundit

    It can be done by adding a custom column to table 1.

    It can be done by adding a custom column to table 1.

    See less
    • 0
  5. Asked: July 7, 2023In:

    Migrate AWS SDK version 2 to version 3.

    Peggy Professional

    When you upgrade to the AWS SDK for JavaScript V3, you will be using a new API. When using V3 API in your project, do not attempt to use V2 calls. As a result, your code will be inaccurate and may break, as you have seen. You can update your code to use V3 logic and calls.

    When you upgrade to the AWS SDK for JavaScript V3, you will be using a new API. When using V3 API in your project, do not attempt to use V2 calls. As a result, your code will be inaccurate and may break, as you have seen. You can update your code to use V3 logic and calls.

    See less
    • 0
  6. Asked: July 7, 2023In:

    Equivalent of the AWS Client command in Boto

    Adithya Pundit

    import boto3 from datetime import datetime, timedelta client = boto3.client('cloudwatch', region_name='up-south-1') response = client.get_metric_statistics( Namespace='AWS/RDS', MetricName='DBLoad', Dimensions=[ { 'Name': 'DBInstanceIdentifier', 'Value': 'sql-rds' }, ], StartTime=datetime(2023, 7, 7Read more

    import boto3
from datetime import datetime, timedelta

client = boto3.client('cloudwatch', region_name='up-south-1')
response = client.get_metric_statistics(
    Namespace='AWS/RDS',
    MetricName='DBLoad',
    Dimensions=[
        {
            'Name': 'DBInstanceIdentifier',
            'Value': 'sql-rds'
        },
    ],
    StartTime=datetime(2023, 7, 7, 21, 0, 0),
    EndTime=datetime(2023, 7, 7, 23, 59, 0),
    Period=60,
    Statistics=['Average']
)

print(response)
    See less
    • 0
  7. Asked: July 7, 2023In:

    Unable to update Conda to a newer version.

    Peggy Professional
    This answer was edited.

    Use the command below: conda update --all conda update -n base conda

    Use the command below:

    conda update --all


    conda update -n base conda
    See less
    • 0
Load More Answers