“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…


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…