Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

server issues: unable to load data to Dataflow-scheduled refresh is successful but table is empty

Submitted by Anonymous on ‎02-21-2023 08:06 AM

The dataflow is configured in 2020 and was running fine till today, there is no change in the datasource or any source data/table properties.

 

The manual/scheduled data refresh of the dataflow shows as successfull but there is no data loaded to dataflow, the tables are empty. The log shows the referesh completed in 3 seconds, please refer the table below row number 3, 5 and 6.

 

I have tried multiple times with modifiying the date ranges, columns and also few other chnages to the dataflow but nothing works.

 

SELECT * FROM db_alterview.vRepodetail

-- EXECUTION RESULTS

--Source is Azure database
-- 23 COLUMNS
-- 209772 ROWS
-- EXECUTED IN 18 SECONDS

-- TABLE SPECS
--Column_name Type Computed Length
--SystemId char no 2
--Id bigint no 8
--calldate datetime2 no 6
--Direction char no 1
--FromTo varchar no 80
--UserId int no 4
--UserOU int no 4
--ServiceId int no 4
--ServiceOU int no 4
--CallType char no 1
--dcontext varchar no 80
--lastapp varchar no 80
--duration int no 4
--billsec int no 4
--disposition varchar no 255
--ccx_callid varchar no 255
--AgentName varchar no 255
--AgentLastName varchar no 255
--AgentEmail varchar no 255
--Service varchar no 255
--Company varchar no 255
--ServiceGroup varchar no 255
--RootOrganizationID int no 4

 

Requested onDataflow nameDataflow refresh statusTable namePartition nameRefresh statusStart timeEnd timeDurationRows processedBytes processed (KB)Max commit (KB)Processor TimeWait timeCompute engineError
2/21/2023 20:50Masked nameCompleteddb_alterview vRepoNACompleted2/21/2023 20:502/21/2023 20:5606:01.6NANANANANANANA
2/21/2023 20:56Completeddb_alterview vRepodetailNACompleted2/21/2023 20:562/21/2023 20:5700:32.1NANANANANANANA
2/21/2023 20:57Completeddb_alterview vRepoCampaignContactNACompleted2/21/2023 20:572/21/2023 20:5902:00.6NANANANANANANA
2/21/2023 20:59Completeddb_alterview vRepoCampaignOrdersNACompleted2/21/2023 20:592/21/2023 20:5900:30.5NANANANANANANA
2/21/2023 20:59Completeddb_alterview vServiceflowNACompleted2/21/2023 20:592/21/2023 21:0000:30.5NANANANANANANA
2/21/2023 21:00Completed NACompleted2/21/2023 21:002/21/2023 21:0000:31.1NANANANANANANA
Status: Needs Info
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎02-21-2023 10:31 PM

Hi @Anonymous 

What if you refresh it manually ? Is it possible to change the data? If you recreate dataflow using the same data source, will the scheduled refresh succeed in updating the data?

 

Best Regards,
Community Support Team _ Ailsa Tao

Anonymous
Not applicable
‎02-22-2023 02:11 AM

Hello,

Manual refresh also results the same (no data is updated).

And Yes when I create the new dataflow (not the legacy) then the data is updated to the new dtaflow tables and also the scheuled refresh updates the data.

We have huge nuber of reports and finding dificult to changing the connection to new dataflow, is there a better way for this issue? please let me know

Idea Statuses