To connect Power BI to CloudMonitor Analytics Engine, you need to send us an email first requesting your Power BI login credentials.
Note: You will not be able to connect the Power BI reports to SQL without contacting our support staff as we need to configure the CloudMonitor Analytics Engine first in order to give you your personal credentials.
If you already have your Power BI login credentials, you can now proceed to connecting your data to view your Azure costs.
Connecting the PowerBI Reporting to the Analytics Engine
Step 1: Click “Connect your data”
From the Power BI Report dashboard, click on the “Connect your data” link found at the topmost part of the page:
Step 2: Enter your SQL Server Name and Storage Account Name
After sending an email, you will receive an email containing the SQL Server Credentials and Azure Storage Account Name. Here’s an example data:
SQL Server Name: example-dbserver.database.windows.net
User Name: CloudMonitor
Password: YourUniquePassword
Azure Storage Account Name: cmsdlestorageacct
Access Key: YourAlphanumericAccessKey
Enter your SQL Server Name and Storage Account Name into the popup screen. Ensure that your daily refresh is set to “On” then hit “Next”.
Step 3: Setup SQL Server Name
Leave the Authentication Method as “Basic” and copy the Username and Password into the textbox. Then set the Privacy level settings as “Organizational“ and click “Sign in and continue”.
Step 4: Setup Storage Account
Set the Authentication Method as “Key”, enter your Account Key into the textbox, and set the Privacy level settings as “Organizational” then click “Sign in and continue”.
Step 5: Click on “Sign in and connect”
After you click on “Sign in and connect,” your Power BI report will refresh and show you your own cost insights.
Note: It may take a while for your data to load depending on how big your data is.
Related Articles
Instructions for Installing CloudMonitor
Step 1: Download the CloudMonitor App into Power BI
Step 2: Download the CloudMonitor Analytics Engine in Azure
Step 3: Configure your Service Principal to Monitor Subscriptions
Step 4: Connect the PowerBI Reporting to the Analytics Engine
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We apprciate your effort and will try to fix the article