Forum Discussion
PowerBI Server (October) DirectQuery to SQL Server table - bug
Hi I have created a PowerBI Report on PowerBI Desktop (October) with a DirectQuery connection to a table on a SQL Server. The report works in PowerBI Desktop (October). When I save it to PowerBI ...
Try storing your credentials (windows or sql) in the server after you publish. You can do this under the data sources tab. The report server now hosts Analysis Services under the covers and that AS server could not connect to your DQ data source.
I was struggling with this error till I found that Report Server DOES NOT SAVE credential in order to have an access to SQL Server after Create the Graphic/Report in Report Server Select it and Select the Option Manage as depiced in Follow
Go to Data Source Tab and make your coonection string and Credential info was input correctly
Click on Test connection if it works that means you are good to go
I hope it helps