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
Hi,
I created a report in the September 2017 release of PowerBI using a direct query data connection from a SQL Server Database table. When I upload the .pbix file into the Report Server, I get this general error when the data is loading:
I am not sure what the issue is. When I upload data from the same table using import, it works fine. Can someone please help?
Solved! Go to Solution.
Direct query connections do not yet work on PowerBI Report Server. You'll have to import your data first then upload, or offload to analysis services server for the moment. Stay tuned for an upcoming release which supports DQ data sources.
Direct query connections do not yet work on PowerBI Report Server. You'll have to import your data first then upload, or offload to analysis services server for the moment. Stay tuned for an upcoming release which supports DQ data sources.
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.
| User | Count |
|---|---|
| 4 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |