help appreciated
4 TopicsGateway Offline Error
For the past few weeks my BI reports fail to refresh on Friday's with the error message stating that my Gateway is Offline. I had my company's IT department investigate and they do not see an issue. Also when I check it appears that the Gateways are all Online even as I received this messages. Anyone experience this issue lately and find a solution? Its strange that this seems to happen every Friday morning.5.8KViews0likes16CommentsPower BI gateway cannot connect to Jira on premise
Hi everyone, I have a Power BI report that uses Power BI connector plugin (by Alpha Serve) to connect to our Jira on premise. It uses oData feed and the url looks something like that – “https://jira.CompanyName.com/plugins/servlet/biconnect/odata/...” Because Jira is on premise and requires access rights and VPN, I was planning to use a gateway. The problem is that the Power BI server doesn’t recognize the need for a gateway and provide the following message and all options are disable: Our assumption is that Power BI server checks if there is a response from this DNS Record on the URL and if there is then it decides that a gateway is not needed. In our case, https://jira.CompanyName.com has a published public DNS record for an integration with AHA, so there is a responce, but it will not work. Any ideas about how to solve this? Do you know if there is a way to force a gateway connection on Power BI service side? Thanks, YaronSolved4.4KViews0likes5CommentsTMSL Alter Column Description
I am a noob in TMSL and I need your help. I am trying to add a description to the column in Power BI Services with a command: { "alter ": { "object": { "database": "dataset_test", "table": "005_SHIP_TO_LOCATIONS", "column":"CREATION_DATE" }, "column": { "name": "CREATION_DATE", "description":"This is the new description" } } } The error I get is: Unrecognized command: alter . Check path '['alter ']', line 2, position 13. Could you help me to make it work? This is Power BI Premium and I TMSL works for table name modification, but I can't figure out how to change the column description.1.2KViews0likes1CommentOn Premise Data Gateway for multiple Organizational Accounts
Let me preface this with I am new to data gateway configuration. I have created a dashboard for a client that pulls data from a database on their server. Currently, I am connected to their VPN to get access to that database within BI. The data gateway is also setup on my computer, which is what I am here to find out how to change. Obviously, if my computer is off and/or I am not connected to their VPN then the client cannot refresh the data on their App. I want to have my client install the on-premise data gateway on their server so: 1) the gateway will always be on 2) the gateway will be on their own network In order to get this to work I'd need to have someone from their Office 365 Organization to sign in and install the gateway, if I'm not mistaken. My question is: I know you can have multiple users as admin on the gateway, but can you have multiple Admins that are from different 365 Organizations? (i.e. my organization so I can continue to update, refresh, and build upon the dashboard, and also my clients organization so they too can access the dashboard refreshes)Solved1.8KViews0likes1Comment