question

Samy-7940 avatar image
0 Votes"
Samy-7940 asked SaurabhSharma-msft commented

Hybrid cloud setup and Data ingestion

Hi All, I have hybrid cloud set up, and we have data ingestion from upstream sources that has set it up in the cloud and ingested in to azure through ADF pipeline, and there are secondary data sources that still on-prem. Our reporting comes off in PowerBI . What would be cost optimized solution also taking in to account the cost perspective so that when the business user view the report or dashboard, it should display integrated enterprise near Realtime data that combines cloud and on-prem data. Any suggestion would be really appreciated. Thanks

azure-data-factory
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @samy-7940,

Thanks for using Microsoft Q&A !!
I suggest you to post your question on Power BI Community as power bi community experts are available there which could help you with your ask. Please let me know if you have any other questions.

Thanks
Saurabh



0 Votes 0 ·

Hi Saurabh thanks a lot. I am sorry for stating the question clearly, actually it is relating to Azure Data Factory. Let's concentrate on ADF design
and leave powerBI aside, my ask is to architectural design in Azure where part of the data comes through ADF pipeline and
other part from on-prem and both data should go to reporting such that it should be integrated reporting solution. Hope it make sense now.
Thanks again.

0 Votes 0 ·

1 Answer

SaurabhSharma-msft avatar image
1 Vote"
SaurabhSharma-msft answered SaurabhSharma-msft commented

@Samy-7940 I suggest you to use SHIR as some of your data is in on-premise. Also, I believe you will have to pull data from cloud and in premise and merge the same to have a real-time data experience. You could also check at PowerBI end as it gives the option of transformation and also connecting to on premise DB using gateway.
Please let me know if you have any questions.

Thanks
Saurabh

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Samy-7940
Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

Thanks
Saurabh

0 Votes 0 ·