topic Re: can't Fetching the Data from Azure in Data Movement & Streaming

can't Fetching the Data from Azure

Rishi_Revanth123 — Wed, 19 Mar 2025 23:08:30 GMT

Hi,

I have to fetch the data from Azure Database. Connections are properly made. In my Database, files are (Example)

stock_2020.xlsx

stock_2021.xlsx

stock_2022.xlsx

1. I want to fetch the latest data. if I use 'For Each *** in Filelist' method. It runs good but not fetching the files.---

Let vExcel_FileLocation='[lib://Azure_Cloud_Data:Azure_Storage_Interface_Data_008]';

I used this ----For Each Files in filelist ('$(vExcel_FileLocation)/Stock*.xlsx')

2. Also I tried storing the maxYear in a variable and used it in the path---

SET vMaxFileYear= 'Num(Date(Year(Today())))';

FROM [lib://Azure_Cloud_Data:Azure_Storage_Sales_Fileshare(Azure)/Stock_$(vMaxFileYear).xlsx]

Note: 'For each' method is perfectly working on Qlik sense Desktop but not in Cloude

Thanks

Re: can't Fetching the Data from Azure

brianjustin — Sat, 27 Aug 2022 16:44:20 GMT

In this post, I am going to share a step-by-step guideline to take Panda Express Guest Survey on www.pandaexpress.com/feedback to win a Free coupon code. You can also get other details related to the Panda Express Survey.

Re: can't Fetching the Data from Azure

Lolale — Fri, 16 Sep 2022 04:27:05 GMT

@Rishi_Revanth123 BayCare Patient Portal App wrote:

Hi,

I have to fetch the data from Azure Database. Connections are properly made. In my Database, files are (Example)

stock_2020.xlsx

stock_2021.xlsx

stock_2022.xlsx

1. I want to fetch the latest data. if I use 'For Each *** in Filelist' method. It runs good but not fetching the files.---

Let vExcel_FileLocation='[lib://Azure_Cloud_Data:Azure_Storage_Interface_Data_008]';

I used this ----For Each Files in filelist ('$(vExcel_FileLocation)/Stock*.xlsx')

2. Also I tried storing the maxYear in a variable and used it in the path---

SET vMaxFileYear= 'Num(Date(Year(Today())))';

FROM [lib://Azure_Cloud_Data:Azure_Storage_Sales_Fileshare(Azure)/Stock_$(vMaxFileYear).xlsx]

Note: 'For each' method is perfectly working on Qlik sense Desktop but not in Cloude

Thanks

That is the thing that I was searching for, what a data present here at this site, thank you administrator.

Re: can't Fetching the Data from Azure

Dianah — Thu, 15 Dec 2022 09:15:33 GMT

Create a data factory.
Create Azure Storage and Azure SQL Database linked services.
Create Azure Blob and Azure SQL Database datasets.
Create a pipeline contains a Copy activity.
Start a pipeline run.
Monitor the pipeline and activity runs.

Regards,

Diana