Forum Discussion

nikola_m's avatar
nikola_m
New Member
1 year ago

PowerBI published report doesn't work

Hi all, 
I have a problem and I tried everything that I could find. 
I create a project in powerBI deskotp, connect to sql database with my credentials, choose table and create view.
I go to publish and choose workspace.
When I try to open report in web browser, i have a problem with connection. Ok, i go to connections, create connection using gateway cluster (which is online and working for other reports on same server), set auth method same on Windows (tried basic too) and enter same crendetials, and connection is created. 
I go to semantic model of my report, map gateway to connection and save everything.

When I run report again I get message "Unable to connecto to data source ___(some alfanumeric)___"
I return to semantic and i can see clearly message "The data gateway ... is online and your data soruces are online"

If someone have idea I would appriciate it

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, nikola_m 

    This looks like a mismatch of authentication methods, you can reconfigure the gateway connection on the Service, I'm using Windows Authentication on my side and everything works fine.

     


    Authentication

     

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum