Symptoms:
Following the steps to create a report in Power BI desktop using FluentPro Power BI package user receives an error '(404) Not Found'.
Such error may occur on the step, when user chooses an OData feed as a data source, provides the User Name and Password for authentication and clicks 'Connect' -
Power Bi Desktop will attempt to load the data, connecting to the provided OData feed URL with the provided credentials.
Instead of the data being loaded, user receives an error -
Cause:
The error message most frequently occurs due to the provided user account credentials not being valid.
Power BI reports built with the help of FluentPro Power BI packages use DataMart OData as data source. In other words, Power BI extracts data from DataMart OData and loads it to the report. To establish connection between Power BI and DataMart OData Basic type of authentication is required - login and password.
If either of integrated authorization modes were used - Office 365, Google or Microsoft - when signing up to DataMart, it would not be possible to establish connection between Power BI and DataMart OData, since for such authentications user's login and password are not used explicitly. They use access tokens instead.
Solutions:
I. Generate a password for your account in DataMart
If you signed up to DataMart using either of integrated authorization modes - Office 365, Google or Microsoft, you can still use your user account, however you would need to set a password for this account in DataMart:
1. Navigate to DataMart and click on your account in the top right corner of the screen. Then choose Personal Settings:
2. In the opened page choose Change your password option.
This option only allows to create or update a password for access to DataMart. The Office365 password will NOT be changed
3. In the opened page type in the password you would like to use to the New password field and repeat the same password in the Confirm new password field.
Then click Change Password
4. You can now use your user name and the freshly generated password to connect to DataMart OData feed in Power BI.
II. Add user to your DataMart via Individual Invitation
In DataMart it is also possible to add a user via individual invitation.
Such user would also need to generate a password to log in to DataMart. Thus, it would be possible to use such user account for connection to DataMart OData feed in Power BI.
Follow the step below to do that:
1. Navigate to DataMart. Click on the gear-like button and choose User Management option.
2. In the User Management page scroll down to Invite more users section.
Type in the email address where invitation will be sent. This can be any email address - personal or work.
Make sure to select Admin option in the Role drop-down!
Then click Send Invitation.
3. DataMart will send invitation to the specified email address.
Open the invitation and follow the link in the email body to proceed.
4. DataMart will be opened in the new tab. Click on the account name in the top right corner of the screen.
Choose Personal settings and update the password.