cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mrecinto Frequent Visitor
Frequent Visitor

azure billing and usage portal MaxDate

Hello, I'm new to PowerBI and found the Azure Usage and Billing Portal from Microsoft.   I implemented this and it works great, however, my AzureEndUsageDate (MaxDate) is always the date I implemented the solution.  I doesn't chagne to anotehr date.  If I want managers to see how much is used to the day, how do I change this?    Is it in the SQL script or in the PowerBI report?

 

Thanks!

 

Mike

 

4 REPLIES 4
mrecinto Frequent Visitor
Frequent Visitor

azure billing portal Azure end date issue (MaxDate)

Hello,

 

I"m not sure this is the correct board.  I'm new to PowerBI. I am a system admin and found the Azure Billing and Portal solution from Microsoft.

I have implemented it and it is great!  However, my 'MaxDate' area is ALWAYS the date that I implemented the solution (11/10/16).

Is there a way to change this so that it is the day the report is run or it is 'today's date'?

 

Thank you,

 

Mike

Moderator v-yuezhe-msft
Moderator

Re: azure billing portal Azure end date issue (MaxDate)

Hi @mrecinto,

Could you please describe more details and post a screenshot about that how you display the report of azure billing and usage portal in Power BI?

If you connect to Azure Enterprise content pack for Power BI, I am afraid that you cannot change the date, you have less control on the content pack. As mentioned in that article, the Azure Enterprise content pack includes monthly reporting data for the range of months that you provide during the connection flow. The range is a moving window, so the dates included will update as the dataset refreshes.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mrecinto Frequent Visitor
Frequent Visitor

Re: azure billing and usage portal MaxDate

Thank you for the reply.

 

Again, I'm new to PowerBI, I'm mainly a server admin who is excited to learn about reporting.   I basically followed all the steps on this link.   https://github.com/Microsoft/AzureUsageAndBillingPortal/blob/master/Documentation/HOWTO.md  

 

 I'm using PowerBI desktop to create the report and the zoomed in area for MaxDate is highlighted in the picture.   It seems static.   I also want to know that I had to get a basic PowerBI account for demonstration purposes, for employee will probably get an Enterprise account if this solution is what they like.  Would that hinder me from any functions relating to updating dates?  

 

My goal is for them or myself to open the report and it changes or updates the MaxDate past 11/10

 

 

screenshot_AzureBilling.JPG

 

Moderator v-yuezhe-msft
Moderator

Re: azure billing and usage portal MaxDate

Hi @mrecinto,

Does the above date come from a field of imported table in Power BI Desktop? If so, is the field updated every day in your table? If the field is updated, you can publish the Power BI Desktop to Power BI Service, and schedule refresh for your dataset and the MaxDate report.

Also check if  you want to achieve the requirement as described in  this blog.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors