A while ago, I came across an error message similar to the one I will be discussing in this post. You will learn how to create R Visuals in Power BI Desktop using the R Script visual. Before creating the visual you have to ensure that the Detected R home directories on Power BI Desktop matches your local R installation path and version. For this example, I have R-3.4.3 installed, so my Detected R home directories from File -> Options…
In this article, you will learn how to import data into Power BI Desktop from an Excel Sheet stored in SharePoint document using the following steps: From SharePoint, open the file in excel, copy the file path and remove? web=1 to look like URL below https://rkc.sharepoint.com/Shared%20Documents/My%20Files/Products.xlsx On Power BI Desktop, from Get Data choose Web connector Enter the above URL and click OK Choose your authentication method, for this example I am choosing Organizational account Click sign in to choose…
You can create high availability clusters of On-premises data gateway installations, to ensure your organization can access on-premises data resources used in Power BI reports and dashboards. Such clusters allow gateway administrators to group gateways to avoid single points of failure in accessing on-premises data resources. The Power BI service always uses the primary gateway in the cluster, unless it’s not available. In that case, the service switches to the next gateway in the cluster, and so on. This article…