{"id":24727,"date":"2018-08-21T05:30:57","date_gmt":"2018-08-21T05:30:57","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=24727"},"modified":"2018-09-11T16:47:15","modified_gmt":"2018-09-11T11:17:15","slug":"power-bi-troubleshooting","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/power-bi-troubleshooting\/","title":{"rendered":"Power BI Troubleshooting – Installation, Data Source & Report"},"content":{"rendered":"

1. Objective<\/h2>\n

In our last tutorial, we discussed Power BI Premium Capacity<\/strong><\/a>. Now, we are going explore Power BI Troubleshooting Tutorial. Moreover, we will learn different issues faced in Power BI like\u00a0Common issues,\u00a0Installation,\u00a0Data sources,\u00a0Reports, and\u00a0Firewall or Proxy.
\nSo, let’s start Power BI Troubleshooting Tutorial.<\/p>\n

\"Power<\/a>

Power BI Troubleshooting – Installation, Data Source & Report<\/p><\/div>\n

2. Power BI\u00a0Troubleshooting<\/h2>\n

A considerable measure of issues can surface when the portal variant is outdated. It is a decent broad practice to ensure you are on the most recent rendition. On the off chance that you haven’t refreshed the passage for multi-month or more, you might need to consider introducing the most recent rendition of the portal and check whether you can imitate the issue.<\/p>\n

3. Types of Power BI Troubleshooting<\/h2>\n

a. Power BI Troubleshooting – Normal Issues<\/h3>\n

Here are a couple of normal issues and resolutions that have helped various clients in conditions that limit web get to.<\/p>\n

i. Confirmation to an Intermediary Server<\/h4>\n

Your intermediary may require confirmation from an area client account. As a matter of course, the passage utilizes a Service SID for the windows benefit sign on a client. Changing the sign on a client to a space client can help with this.
\nDo you know about Power BI Free vs Pro (Paid)?<\/a><\/strong><\/p>\n

ii. Your Intermediary just Permits Ports 80 and 443 Movement<\/h4>\n

A few intermediaries limit activity to just ports 80 and 443. As a matter of course, correspondence to Azure Service Bus will happen on ports other than 443.
\nYou can compel the portal to speak with Azure Service Bus utilizing HTTPS rather than coordinate TCP. You should alter the Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config record. Change the incentive from AutoDetect to Https. This document is situated, of course, at C:\\Program Files\\On-premises information door.<\/p>\n

<setting name=\"ServiceBusSystemConnectivityModeString\" serializeAs=\"String\">\r\n<value>Https<\/value>\r\n<\/setting><\/pre>\n
b.\u00a0Power BI Troubleshooting –\u00a0Installation<\/h3>\n
i. Failed to add a user to a group.<\/h4>\n
Failed to add a user to a group (- 2147463168 PBIEgwService Performance Log Users). You may get this error on the off chance that you are attempting to introduce the entryway on a space controller. Sending on an area controller isn’t bolstered. You should convey the door on a machine that isn’t an area controller.<\/p>\n
ii. Installation falls flat<\/h4>\n
You may experience establishment disappointments if the counter infection programming on the establishment machine is obsolete. You can either refresh the counter infection establishment or incapacitate hostile to infection just for the length of the passage establishment to finish, at that point re-empower against infection.<\/p>\n
c.\u00a0Power BI Troubleshooting –\u00a0Information Sources<\/h3>\n
i. Error: 1<\/h4>\n
 Unable to Connect. Points of interest: “Invalid association certifications”<\/em>
\nInside Show subtle elements, it should show the error message got from the information source.
\nLogin fizzled for client ‘username’.
\nCheck that you have the right username and secret word. Likewise, confirm that those qualifications can effectively associate with the information source. Ensure the record being utilized matches the Authentication Method.
\nFollow this link to know How to Shape and Join Information in Power BI Desktop<\/a><\/strong><\/p>\n
ii. Error: 2<\/h4>\n
Unable to Connect. Points of interest: “Can’t interface with the database”<\/em>
\nWe could interface with the server, yet not to the database provided. Confirm the name of the database, and that the client qualification as the best possible consent to get to that database.
\nShow points of interest, it should show the error message got from the information source. For SQL Server, you should see something like the accompanying.
\nCan’t open database “AdventureWorks” asked for by the login. The login fizzled. Login fizzled for client ‘username’.<\/p>\n
iii. Error: 3<\/h4>\n
 Unable to Connect. Points of interest: “Obscure error in information portal”<\/em>
\nThis error could happen for various reasons. Make sure to approve that you can associate with the information source from the machine facilitating the portal. This could be the consequence of the server not being open.
\nInside Show subtle elements, you will see an error code of DM_GWPipeline_UnknownError.<\/strong>
\nYou can likewise look in the Event Logs > Applications and Services Logs > On-premises information portal Service for more points of interest.<\/p>\n
d.\u00a0Power BI Troubleshooting –\u00a0Reports<\/h3>\n
A report couldn’t get to the information source since you don’t approach our information source by means of an On-premises information entryway.
\nThis is typically caused by one of the accompanyings.
\nThe information source data does not coordinate what is in the fundamental dataset. The server and database name need to coordinate between the information source characterized by the On-premises information passage and what you supply inside Power BI Desktop. On the off chance that you utilize an IP Address in Power BI Desktop, the information source, for the On-premises information door, needs to utilize an IP Address also.
\nThere isn’t an information source accessible on any passage inside your association. You can arrange the information source on another, or exist, On-premises information passage.
\nHave a look – How to Use Analytics Pane in Power BI Desktop?<\/a><\/strong>
\ni. Error: Data source gets to blunder. It would be ideal if you contact the portal overseer.<\/strong>
\nOn the off chance that this report is making utilization of a live Analysis Services association, you could be experiencing an issue with an esteem being passed to EffectiveUserName that is either not substantial or doesn’t have consents on the Analysis Services machine. Normally, a validation issue is because of the way that the esteem being passed for EffectiveUserName doesn’t coordinate a nearby client key name (UPN).
\nTo affirm this, you can do the accompanying.
\nLocate the powerful username inside the passage logs.
\nWhen you have the esteem being passed, approve that it is right. On the off chance that it is your client, you can utilize the accompanying charge from a summon provoke to perceive what the UPN ought to be. The UPN will resemble an email address.
\nwhoami\/<\/strong>upn
\nAlternatively, you can perceive what Power BI gets from Azure Active Directory.
\nPeruse to https:\/\/developer.microsoft.com\/chart\/diagram wayfarer<\/strong>.
\nSelect Sign in the upper right.
\nRun the accompanying inquiry. You will see a fairly substantial JSON reaction.
\nhttps:\/\/graph.windows.net\/me?api-version=1.5<\/strong>
\nSearch for userPrincipalName.
\nIn the event that your Azure Active Directory UPN doesn’t coordinate your nearby Active Directory UPN, you can utilize the Map client names highlight to supplant it with a substantial esteem. Or on the other hand, you can work with either your occupant administrator or neighbourhood Active Directory administrator, to get your UPN changed.<\/p>\n
e.\u00a0Power BI Troubleshooting –\u00a0Firewall or Proxy<\/h3>\n
For data on giving intermediary data to your door.
\nYou can test to check whether your firewall or intermediary, might square associations by running Test-NetConnection from a PowerShell incite. This will test network to the Azure Service Bus. This exclusive tests arrange network and don’t have anything to do with the cloud server benefit or the passage. It decides whether your machine can really get out to the web.
\nTest-NetConnection – ComputerName watchdog.servicebus.windows.net – Port 9350<\/strong>
\nNote –<\/strong>\u00a0Test-NetConnection is just accessible on Windows Server 2012 R2 and later. It is likewise accessible on Windows 8.1 and later. On prior OS variants, you can utilize Telnet to test port network.<\/em>
\nThe outcomes should appear to be like the accompanying. The distinction will be with TcpTestSucceeded. In the event that TcpTestSucceeded isn’t valid, at that point, you might be obstructed by a firewall.
\nComputerName:<\/strong> watchdog.servicebus.windows.net
\nRemoteAddress:<\/strong> 70.37.104.240
\nRemotePort:<\/strong> 5672
\nInterfaceAlias:<\/strong> vEthernet (Broadcom NetXtreme Gigabit Ethernet – Virtual Switch)
\nSourceAddress:<\/strong> 10.120.60.105
\nPingSucceeded:<\/strong> False
\nPingReplyDetails (RTT):<\/strong> 0 ms
\nTcpTestSucceeded:<\/strong> True
\nIn the event that you need to be comprehensive, substitute the ComputerName and Port qualities with those recorded for ports.
\nFollow this link to know Data Sources for Power BI Benefit (Services)<\/a><\/strong>
\nThe firewall may likewise be obstructing the associations that the Azure Service Bus makes to the Azure server farms. On the off chance that that is the situation, you will need to whitelist (unblock) the IP addresses for your area for those server farms. You can get a rundown of Azure IP addresses here.
\nYou can discover the server farm district you are in by doing the accompanying:<\/p>\n
    \n
  1. Select the ? in the upper right of the Power BI benefit.<\/li>\n<\/ol>\n
      \n
    1. Select About Power BI.<\/li>\n<\/ol>\n
        \n
      1. Your information locale will be recorded in your information is put away in.<\/li>\n<\/ol>\n
        On the off chance that you are still not getting anyplace, you could take a stab at getting a system to follow utilizing a device like a fiddler or netsh, in spite of the fact that these are propelled accumulation strategies and you may require help with examining the gathered information. You can contact bolster for help.<\/p>\n
        f. Power BI Troubleshooting –\u00a0Performance<\/h3>\n
        i. Performance Counters<\/h4>\n
        There are various Performance counters that can be utilized to measure the exercises for the passage. These can\u00a0useful for comprehension on the off chance that we have an expansive heap of action and may need to make another door. These counters won’t reflect what extent something takes.
        \nThese counters can access through the Windows Performance Monitor instrument.
        \nThere are general groupings of these counters.
        \nCounter Type Description<\/p>\n