"The user was not authorized" on data source connection at Power BI Desktop

Hello, We have recently managed an issue which resolution may help to most of you. For so, we would to share it here. It is about data source connection in Power BI Desktop application and in our case we were using OData Feed connection. If you get the following error “The user was not authorized”, the first…


Errors in a new MDS web site (I) : Access is Denied

  In this series of post, I am going to show you the most common (and not so common) problems we can find when creating a new web site and how to troubleshoot them. The access denied error when deploying a web site in Master Data Services, is one of the most classical issues, and…


“The user was not authorized” error when connecting to Project Online

  Some users are experimenting authentication issues when using Project Online as a data source. This authentication issue causes an error just when importing data, but the connection is performed properly. Let’s suppose the scenario below: In Power BI Desktop click on Get Data > OData feed and type the url to connect to your…


Unable to access Power BI Admin Center

  If you have recently acquired a license for Microsoft Power BI, you have probably experimented the issue below when trying to access Power BI Admin Center: What does this error mean? Are we missing something? Power BI Admin center is part of the old version, Power BI for Office 365. In the new version…


Unsupported data sources types detected

Sometimes, when creating a Power Query data source on Power Bi, we get the message below after validating the connection string: First of all, is your data source within the list of supported data sources? Let’s check on this link: https://support.office.com/en-us/article/Supported-Data-Sources-and-Data-Types-cb69a30a-2225-451f-a9d0-59d24419782e If so, the problem could be in the Power Query transformation. Following expressions are…


Testing connections in Scheduled Data Refresh

  In Power BI, when we want to create or modify a scheduled data refresh, we usually find the “Save and refresh report” and “Save Settings” buttons disabled: To enable these buttons you have to click on test connection in order to check that everything is fine in the data source. If this check is…


Changing Report Viewer control credentials

  If you have a Web Forms application containing a Report Viewer control, and you want to specify the credentials used to access your report server, you may have noticed that it is not as easy as you thought.   The property NetworkCredentials stores the user and password that we want use to execute the…


Intermitent HTTP 401 error message in a SSRS load balancing deployment.

In a SSRS load balancing deployment, you get intermitently HTTP 401 error message when you do any action that requires connection from one node to the other RS node    When you access to Report Manager using the balancer virtual name (http://<virtualname>/Reports) , you can intermittently get HTTP 401 error message when you do any action…


Configure a Report Server on a load balancing deployment

  Although the main steps to configure Reporting Services are on the msdn article below, sometimes you can find additional errors trying to access Report Manager or Report Server URLs a load balancer deployment. You will find in this blog some additional steps that will help you.                  Configure a Report Server on a…


HTTP 401 error when you access to Report Manager in a load balancing deployment.

In a Reporting  Services load balancing deployment, you receive the following error message while you access to Report Manager using the balancer virtual name in the URL: “The request failed with HTTP Status 401” However, the Report Server URL works properly. This is solved by configuring the ReportServerURL setting on the rsreportserver.config file.             On…