Forum Discussion
On-Demand refresh failed - Gateway Timeout - SharePoint Document Library
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?
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
You could do it with dataflows using landing dataflows for your raw tables, then appending them in a child dataflow.
