Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
I've got a Power BI file that i've published into Power BI Web. The project has 5 data sources. 2 SQL databases and a 3 excel files.
I've configured the gateway and i get the successful linkage as below:
When i attempt to click "Apply" i'm met with the following error:
For troubleshooting i've split the file up into the 3 source groups. 1 file for each SQL and another for the group of excel files. Individually, none have an error. When i have them all together this cryptic mess of an error appears. Does anyone have any ideas of what might be causing the problem? I'm able to refresh fine using the refresh button on Power BI desktop.
Solved! Go to Solution.
I've gone through each of my tables and removed any "Hide in report view" that i have selected. This appears to be causing the error i have shown here.
I've gone through each of my tables and removed any "Hide in report view" that i have selected. This appears to be causing the error i have shown here.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.