Forum Discussion
Simple DataFlow Failing Refresh
Hi seattle3 It might be a processing issue when handling multiple tables in the dataflow. Since each table refreshes fine individually, try refreshing them separately to identify the issue. You can check Refresh History under Dataflow settings for more details or test the query in Power Query Editor for errors.
Thanks V-yubandi-msft for the pointers. Power BI should have the correct permissions to access the file (otherwise how would I be able to see the file contents when creating the data flow?).
I didn't add any transformation steps, all I did was create a data flow select two tables from my XL file and saved. Power BI auto added changing the column types, but that's it.
When you say to check the error logs for detailed information how do I do that? The Excel "report" I get when looking at the refresh history just tells me the table name (which has no transformations beyond loading the table and setting the column types) and the error is just the request id and activity id.
Community SupportYou are correct if Power BI allows access to the file during dataflow creation, permissions are likely not the issue. Since the only transformations involve setting column types, the problem may be elsewhere.
1. Check Power BI Admin Portal Logs (if you have admin access) for detailed error messages.
2. Refresh each table separately to see if a specific table is causing the issue when both are combined.
Thanks...