Forum Discussion
On-Demand refresh failed - Gateway Timeout - SharePoint Document Library
Hello everyone, I am facing this initial refresh failing when trying to do an on-demand refresh after configuring incremental refresh settings and publishing report to power bi servive. I hav...
UNION the tables in DAX instead. Also read about bootstrapping partitions.
Troubleshoot incremental refresh and real-time data in Power BI - Power BI | Microsoft Docs
Okay so, this is what completed my initial refresh.
The query where I was combining all the 6 tables into 1, I removed it. I removed the append as new query and published the report. When I made initial refresh, it took 1h 45m but eventually was completed.
However, I still need to combine all tables. Is there anything else I can do to achieve this?
lbendlin
Super User
Super UserUNION the tables in DAX instead. Also read about bootstrapping partitions.
Troubleshoot incremental refresh and real-time data in Power BI - Power BI | Microsoft Docs