![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Power BI Real Time Data Optimisation
- or -
Post a project like this£40/hr(approx. $51/hr)
- Posted:
- Proposals: 19
- Remote
- #4112564
- Expired
Python, OpenAI, ChatGPT |Microsoft Fabric| Synapse| SQL Server, Snowflake ❄️, Postgres, MySQL| Power BI, Tableau, Domo | Azure, AWS, GCP| SSIS, Alteryx |AirFlow|AirByte|DBT| DevOps
Full stack Asp.Net MVC, .Net Core, C#, MS SQL, WordPress developer
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
1066418518533793250427197371109561149432710621775
![Aku A.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/e02950dfbb6b1d6c1b1cdc5f0df488e5_70x70.jpg)
![Mihir O.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/3dae6466fd86c4a1239bc08bfa1b9666_70x70.jpg)
![Manish K.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/902bcfeab168ec8a638c8209e6660fae_70x70.png)
![Hema M.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/da7fb97d21f0fa3c07204383f9dff7dc_70x70.png)
Description
Experience Level: Expert
I am monitoring a number of sensors which get polled via Modbus every second. This data goes straight to an SQL Database on AZURE.
The data is pulled into Power BI via partitioned table - 1 day is 'archived', 1 day in 'incremental' and real time is enabled.
Various Dax queries are used to return the most recent values as well as add some together to total various sensor data together.
However the reports are not refreshing as quick as I need - I need them to refresh every second for some data.
I am looking for someone who has specific experience with real time data in PowerBI to analyse my reports and DAX queries, and suggest improvements to make it real time.
The data is pulled into Power BI via partitioned table - 1 day is 'archived', 1 day in 'incremental' and real time is enabled.
Various Dax queries are used to return the most recent values as well as add some together to total various sensor data together.
However the reports are not refreshing as quick as I need - I need them to refresh every second for some data.
I am looking for someone who has specific experience with real time data in PowerBI to analyse my reports and DAX queries, and suggest improvements to make it real time.
![Simon G.](https://www.peopleperhour.com/imgs/default_avatar_light_70x70.png)
Simon G.
100% (7)Projects Completed
5
Freelancers worked with
5
Projects awarded
32%
Last project
11 Feb 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies