I am using Dataflow Gen1 in the Pro workspace of the Power BI service to connect to an on-premise SQL Server database using On-premise Gateway. A few months ago, everything was working fine. However, for the past couple of months, the refresh has been failing. When I refresh the data from the M-Query of the dataflow it works but when I refresh the dataflow it's failing.
In the error message export from the dataflow nothing is specified. it says ony Error : Request ID : and Activity ID.
Here are the steps I have thoroughly checked:
- No premium transformations or features are used in the dataflow. I even tried using a basic table with 100 rows without any transformations, but it still failed.
- I checked the Gateway connection configuration. It is working fine, as the same Gateway connection is being used to refresh the dataset, and it works.
The on-premises data gateway is up to date.
I recreated the dataflow multiple times in different Pro workspaces with different users and still the issue is persists.
I also checked that, the same dataflow is working perfectly fine when I use the Premium workspace.
Has anyone experienced a similar issue or have any suggestions?
v-xiaoyan-msft
on:
[BUG] mailto: protocol fails when used in web URL ...
Hi @Iras,
Based on the above information, this issue is complex which may need to collect log files for further troubleshooting. Since community support engineers don't have that access, I would suggest opening a Support Ticket. If you are a Power BI Pro or Fabric licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.
The link of Power BI Support: Support | Microsoft Power BI
For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community
Best Regards,
Community Support Team _ Caitlyn