Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 ...
DirectQuery
Power BI Report Server
  • Jon-Heide's avatar
    Jon-Heide
    8 years ago

    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. 

Jon-Heide's avatar
Jon-Heide
Microsoft Employee
8 years ago

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. 

sblakeb's avatar
sblakeb
Regular Visitor
8 years ago

My group releases reports for other people we don't want to use our own credentials when the report runs. (or a service account for that matter) We want the person who runs the report to have their AD credentials passed through to the SQL server so we know which user is taking the SQL resources. Also its a second layer of security. One to the report itself, and second to the database. Anyone able to get pass though credentials working for direct query data sources?

~Blake