Forum Discussion

AndresPesca's avatar
AndresPesca
Frequent Visitor
4 years ago

Unable to connect to web server data source

Hi Community,

 

I’m trying to connect to this web server "cubos3.sispro.gov.co" through Power BI. I can succesfully connect from excel through a "Analysis Services" connector, how ever when I try to connect from Power BI Desktop I get this error "DataSource.Error: AnalysisServices: A connection cannot be made. Ensure that the server is running."

 

Am I doing something wrong? How can I repplicate excel connection to Power BI?

 

Best Regards,

Need Help

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    4 years ago

    Hi AndresPesca 

     

    I would chat to the owner of the web server "cubos3.sispro.gov.co" and see how to correctly connect.

    • AndresPesca's avatar
      AndresPesca
      Frequent Visitor
      4 years ago

      Hi GIlbert,

      Thanks for your reply. The server if from the gouvernement, before posting I try to connect with them but with no succes.

      Is not a solution but in any case thanks for the advice.

      Best Regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi AndresPesca ，

     

    How do you connect to this web connector, also use "analysis services"connector or other way? what data source you want to get through connecting to web server?

     

    Can you give me your detailed steps about the process of connecting to web server? I'll appreciate for this information.

     

    Best regards,

    Community Support Team Selina zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

    • AndresPesca's avatar
      AndresPesca
      Frequent Visitor
      4 years ago

      Hi Anonymous,

      Thanks for your reply,

       

      I’ll show the connection process for Excel where the procces is succesfull. As I told you I use the "Analysis Service" connector from excel. That pop up the wizard shown in the picture.

       

      Once I provide the server name, user and password the following windows pop-up. Then I choose the first table that contain the data I need.

       

      After I press finish and then, the connection brings me all the information I need to work with. And let me use it on a Dynamic Table.

       

      I need to replicate this process from Power BI Desktop in order to edit the data from there, however when I try to connect with the same connector, I get the error showed in my first post.

       

      Appreciate your help.

      Andrés