data gateway

7 Topics

How to connect my on premises data gateway in personal mode
Hello everyone, I am new to Power BI and trying to connect my on premises data gateway in personal mode with my dataset. My data is saved on a mariadb data base. I am following this tutorial: Power BI Data Gateway in Personal Mode: Installation and Usage Tips Until 5:27 I could follow all steps By 6:20 the screen of the tutorial and mine is different: My screen: Does anyone has an idea what I have to do? Do I need to change any settings at my on premises data gateway in personal mode?
Solved
hish
1 year ago Place Service
3.4KViews
0likes
4Comments
Gateway Error
Hi All, I have a report with source as SQL. I have deployed that report in the service. To schedule the refresh for that report, it is required to install and configure Gateway. So, i tried to install the Personal Gateway first, it got installed, but unable to configure it with my account. Similalry i have tried Standard gateway also, (uninstalled the personal and installed the Standard) even then getting the same issue. Below is the error screenshot of it. The above mentioned is everything performed in one of our Servers. The same process i have done in my base machine, and it is working fine. Only issue is in the Server. Please help or provide any solution for this. Thanks, Sudharshan.
Sudharshan1919
3 years ago Place Service
6KViews
0likes
1Comment
Data gateway - Should I Install and where to install?
Good day everyone! A rookie question. My objective is to distribute completed power BI report to users through web interface. I have subscribed with Power BI Pro version. I used Power BI desktop to make the report and the deliverable is just one .pbix file that connecting to SQL Server 2012 for data source. I build the same report with both way of querying SQL server (Import and direct query). And I uploaded both reports to my workspace. Both report got error when I tried to open it in my workspace: For the one database connection is using "Import", it can display the dashboard like barchart things. But if I click on the dataset "Refresh" button it said "Something went wrong - Scheduled refresh has been disabled. Please try again later or contact support. If you contact support, please provide these details." "Data source errorScheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh. Cluster URIWABI-NORTH-EUROPE-D-PRIMARY-redirect.analysis.windows.net Activity ID0cb0327e-9259-4980-bcc2-68dc7a1daca7 Request IDac1a381a-5d11-939c-f94f-37e5722ffae2 Time2023-01-05 08:37:13Z" For the one database connection is using "Direct Query", it cannot display the dashboard (as no data inside). When I first click on the report it already shows a red ribbon at the top of the screen "There is no gateway to access the data source [myDBName]." as well as "Data source unreachable - There is no gateway to access the data source en02live . Verify the gateway connection configuration on the dataset settings page and make sure all required data sources are added to the selected data gateway." The current infra setup here is : - SQL Server 2012 (the data source and I use internal IP address to access to it) - My laptop with SSMS (I use this to query and create a temp table. And this is where the Power BI dashboard load data from) - My laptop with PowerBIDesktop installed (I use this to develop the report) - My workspace (that is my login under my 365 account which subscribed as Pro user) So, questions are: It seems my next step I need a "data gateway" in place. However I have no idea where should I put that gateway in? Shall I install the on premise gateway in SQL server? The gateway setup: it seems allows me to login using my 365 account. But it does not have setup to connect to my SQL server by putting in credential and ip/host name of my data source (i.e., SQL Server). How that data gateway works? If I need to distribute the report to users, do I need to get extra Pro license for them? We have at most 5 to 6 users only that need to access Power BI report. Thanks a million for all advices or sharing of link that help me to make this come true.
Solved
henrytang
3 years ago Place Service
4.1KViews
0likes
1Comment
Can't connect to data-source
Hi, trying to setup a PowerBI data source via on-prem gateway. I have installed gateway, created the data source but i cannot work out how to actually use the data-source. Can anyone please help. The data-source is RDS-aurora
Solved
slavka1979
4 years ago Place Service
768Views
0likes
1Comment
Reports fails to refresh through On-premises data gateway.
Hello Everyone, I am facing an issue while refreshing Power BI reports through gateway. The issue is, my reports are failed to refresh when I tried to refresh them through on-premises data gateway, but the same reports are refreshing successfully through personal data gateway. I am providing same credentials to both the gateways while creating data source into them. For your information, Backend source of report is MS Access and it is located on network drive. Thanks, Vivek C
Anonymous
6 years ago Place Service
745Views
0likes
2Comments
Data Gateway (DM_GWPipeline_UnknownError)
Hi, i've tried to get connection from my analysis service to my power bi service with data gateway and get following error: GatewayPipelineErrorCode=DM_GWPipeline_UnknownError GatewayVersion= InnerType=AdomdErrorResponseException InnerMessage=<pi>Parser für XMLA (XML for Analysis): the'[email protected]' value of the 'effectiveUserName' xml for analysis property is not valid .</pi> InnerToString=<pi>Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Parser für XMLA (XML for Analysis): the [email protected] of XMLA-Eigenschaft (XML for Analysis) 'EffectiveUserName' is not valid. bei Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA) bei Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) bei Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() bei Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync()</pi> InnerCallStack= bei Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA) bei Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) bei Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() bei Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync() ([1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException.StackTrace:) bei Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA) bei Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) bei Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() bei Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync() I've done my mapping of Username correct i think. Mapped my Office Account to my Domain Adress. Can anybody help me?? Thanks!!!!
DomZ
6 years ago Place Service
1.4KViews
0likes
1Comment
Connect to multiple tables on the same SQL server using data gateway
Apologies if this has been asked before, I am trying to connect to multiple tables on the same SQL server. My report contains two queries, both referencing two different tables on the same server. THese run fine both within SQL and in the report. I'm trying to set up the report for a scheduled refresh using the data gateway, however I can't get it to connect. This worked fine when I was just referencing the one table but it won't connect to the second table. I've tried adding it in Manage Gateways with no luck. What am I doing wrong? Thank you.
Anonymous
6 years ago Place Service
2.9KViews
0likes
4Comments