cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Log Weekly Results into New Table

Hello Everyone,

 

I have a report in the Power BI that shows the total compliance percentage of the security installed of each location we have around the factory.  The report refreshes daily and the data comes from an SQL table.

 

I would like to log the results from the report each week into a new table and then use that table to show a change in historical compliance percentage every week. 

 

Any help would be greatly appreciated.

5 REPLIES 5
v-robertq-msft
Community Support
Community Support

Hi, @Anonymous 

If the total compliance percentage is calculated using the measure in Power BI, I don’t think the value of the historical compliance percentage can be inserted into a new table every week. Because the data is updating and the measure can only calculate based on the current data. The historical data can not be recorded in Power BI.

Maybe you can find the solution using procedures in SqlServer.

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Hello Robert,

 

Thank you for your reply.

 

Yes, you are correct the total compliance percentage calculation is happening using the measure. 

 

Have you ever tried this via procedures in SQL server?

 

Hi, @Anonymous 

If you want to implement this function in Sqlserver, I think you need to create a historical data table first, then write a stored procedure to insert data into the historical table, and set up a timing job for this stored procedure to execute it regularly. For a more specific implementation process, I suggest you to go to the SqlServer community to open a case so that experts in SqlServer can help you in advance.

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin
Super User
Super User

why new table?

 

Your data acquisition process sounds exactly like what incremental refresh is about.

Anonymous
Not applicable

Hello,

 

Thank you for your reply.

 

We are calculating the compliance percentage at the PowerBI side and only the raw data is coming from the SQL from which we are doing all the calculations. 

Helpful resources

Announcements
Power BI Show Ep 4 Post Show Carousel.jpg

The Power BI Community Show

Shabnam Watson demos Incremental refresh & Hybrid Tables and Leila Etaati demos Charticulator.

PBI April Release 2022 768x460.png

Check it out!

Click here to read more about the April 2022 updates!

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors