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. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello,

 

we are still facing this issue with Power BI Desktop January 2019 version.

 

1. We created a new report using DirectQuery

2. Get Data -> SQL Server Database -> Enter Server IP (or Name, we tried both) -> Select View -> DirectQuery

3. Database Username + Passwort

4. We can see data

5. Publish the report to the (OnPremise) Power-BI Report Server

6. Set Username + Password again inside the "Manage" Tab.

7. Check connection: Connection is successful

8. Open report in the browser -> The error msg is shown instead of data ;)

 

Power BI - Report Server:  1.4.6969.7395 (Januar 2019) 

Power BI - Desktop: 2.65.5313.1562 32-bit (Januar 2019)

 

Any ideas?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Anonymous wrote:

    Hello,

     

    we are still facing this issue with Power BI Desktop January 2019 version.

     

    1. We created a new report using DirectQuery

    2. Get Data -> SQL Server Database -> Enter Server IP (or Name, we tried both) -> Select View -> DirectQuery

    3. Database Username + Passwort

    4. We can see data

    5. Publish the report to the (OnPremise) Power-BI Report Server

    6. Set Username + Password again inside the "Manage" Tab.

    7. Check connection: Connection is successful

    8. Open report in the browser -> The error msg is shown instead of data ;)

     

    Power BI - Report Server:  1.4.6969.7395 (Januar 2019) 

    Power BI - Desktop: 2.65.5313.1562 32-bit (Januar 2019)

     

    Any ideas?


    Hi there,

     

    i am running into the same issue with the September 2019 setup. Does sombody knowing a solution/workaround?

    Besides SQL we are trying to connect to Oracle as well. I am wondering if this has something to do with Kerberos delegation, becaue source servers and report server are not on the same machine? 

     

    Cheers,

    Mogry