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 for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
5 | |
3 | |
1 | |
1 | |
1 |