Dataflow Refresh

[Anonymous]

Team,

Need help, I have created a dataflow in power bi service. The data inflow is coming from the REST API and it only has 20,0000 records as of now since the data is still under the testing phase.

Now my problem is that my dataflow was refreshing as per my schedule without any issue still yesterday. But since I have included an additional column in one of my query my dataflow keeps on failing on the same table query.

The flow has 17 different queries running and extracting data from different tables.

Now I am unable to find the reason for this issue.

Shall I create separate dataflow for each different query? Please help

[v-lionel-msft]

Hi @Anonymous ,

Has your problem been solved? If yes please consider accept the solution to help the other members find it more quickly.

Best regards,
Lionel Chen

[Anonymous]

hi @v-lionel-msft 

Sorry for the delay . My issue is resolved now.

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

1. Check if the data source can be accessed normally.
2. Check the network status and gateway service status.
3. Enter the entity editing panel and check whether the dataflow has errors, like these:

 

If tthe problem still can't be solved, please create support ticket .

Best regards,
Lionel Chen

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

[venal]

@Anonymous 

Can you please share the error message by downloading it fromt he refresh history.

If possible, can you please tryt to remove and re-add that particular entity which is causing the issue.

If you have any queries, please revert.

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

BR

venal.

[Anonymous]

@venal 

I am getting this error "There was a problem refreshing your dataflow. {"RootActivityId":"f25fc567-6eaf-91a5-074d-10219ce43bf9"}"

I deleted the entity causing the error and created it again but of no use.

Not sure what am I missing here. 

[venal]

@Anonymous 

Please create support ticket to investigate the issue with the below error details.

1. Latest Error Message (download it from refresh history and share the .csv file)

2. Cluster ( Power bi service >> ? (Help & Support) >> About Power BI, share the screenshot)

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

BR

venal.