Dataflow Gen 1 not refreshing

[EmilZPM]

Hey all,

I am trying to set up a Dataflow Gen 1 in PowerBI. It loads data from Azure Blob storage.
The only transformation I am doing is to extract 4 different values, to create new columns.

The preview looks perfectly fine.
I am connected to the same source, with the same credentials through PowerBI Desktop, and it refreshes without any issues. 

When I try to refresh the Dataflow, it stops after 30 seconds and fails, with no error message besides Activity and Request ID.

I hope some of you might be able to help me out.

[v-ssriganesh]

Hi @EmilZPM,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

[EmilZPM]

Sorry for the lack of response.
I am still facing the same issue, even though I tried all the suggested solutions. As for now I can't upgrade to a Gen 2, since I do not have a fabric license.

For now I have put it on hold, and may try other ways.

[v-ssriganesh · Accepted solution]

Hi @EmilZPM,
We regret the inconvenience caused and acknowledges your requirements. Please consider raising a Microsoft support ticket. You can create a Microsoft support ticket using the link below:
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.

Thank you.

[v-ssriganesh]

Hi @EmilZPM,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-ssriganesh]

Hi @EmilZPM,

I thank you for bringing your issue to the attention of the community. I understand that you have trouble in refreshing your Dataflow Gen 1 in Power BI after loading data from Azure Blob storage. Please try these few items to fix the issue:

• The preview looks fine, so the issue may lie in the transformation logic during the refresh. Ensure the M query is optimized and free of unnecessary steps. Test the transformation in Power BI Desktop to verify its functionality.
• Double-check the credentials used in the Dataflow to ensure they have the correct permissions to access the Azure Blob Storage. Re-enter the credentials in the Dataflow settings to rule out authentication issues.
• In the Power BI Service, navigate to the Dataflow settings and enable diagnostic logging. This might provide more detailed error messages to help pinpoint the issue.
• Try refreshing the Dataflow with a smaller subset of the data. This can help determine if the issue is related to data size or complexity.
• Consider upgrading to Dataflow Gen 2 for better performance, improved error handling, and higher limits to prevent future issues.
• If you are utilizing a Premium workspace, please verify that the Enhanced Compute Engine is enabled. Occasionally, turning this setting off and on again can help address refresh issues. Additionally, if you are using an on-premises data gateway, ensure it is online and properly configured.

If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Thank you.

[lbendlin]

Many issues with Gen1 dataflows at the moment.  If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .