Forum Discussion

SvenTexas's avatar
SvenTexas
Frequent Visitor
10 years ago
Solved

Published Power BI report using web service to get data from DMZ

Hi.  I have a published a dashboard on PowerBI.com using a static datasource, but now need to link the dashboard to a live SQL database curently on site.  Can anyone detail the steps to re:webservice...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    Hi SvenTexas,

     

    It seems the issue is solved. Would you please mark the helpful reply as an answer?

     

    Best Regards,
    Qiuyun Yu

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

SvenTexas The only way currently is to use pbix file within power bi desktop and via query editor change the source and save. Then republish to power bi service which will replace your published dataset with the new one. Ofcourse you will then need to setup gateway and depending on the mechanism you're using to data source such as directquery.

  • SvenTexas's avatar
    SvenTexas
    Frequent Visitor
    10 years ago

    Thankyou ankitpatira, what is involved in setting up the gateway? I guess our network guys would set that up - would there be anything that I would have to give them to help?

     

    Thanks.