object reference not set to an instance of an object while signing in

[masmus]

Hi,

We get "something went wrong object reference not set to an instance of an object" while trying to log in to organisation account to connect to Power Query.

It worked fine tuesday 26.10, but it seems like a new version of Power BI desktop is installed 27.10, could this interfere with Power Query login?

[JulianNoarmenn]

what data source are you using? 

Depending on the data source used, the fix is ​​different. Take a look at the list of fixes according to the datasource here: https://powerbipoint.com/2024/01/02/power-bi-fix-the-error-object-reference-not-set-to-an-instance-o... 

[Jith_Raphael]

Check you privacy level settings in Power bi desktop options and update the privacy level accordingly and try to refresh.

[PeterNL]

*Fixed it*

For people with the same error message. Previously i opened a sharepoint excel file in the desktop app and kopied the path from there. File -> properties-> location. 

When i copied the path from sharepoint online and replaced the old path it worked again. Select the Sharepoint Excel file -> scroll down on the menu that apears on the right and copy the path. 

Hope this helps somebody. 🙂 

[fsim]

Hi there ! On my side the problem is no more.

My last connection was on an excel file shared in  a Teams. and this connection worked (using Organisational account sgin in)

= Excel.Workbook(Web.Contents("https://myorg.sharepoint.com/teams/TeamsName/Shared Documents/General/Power BI/TabelConvertedNames.xlsx"), null, true)

[PeterNL]

Same here!

[v-eqin-msft]

Hi @fsim ,

If you still cannot solve the issue,sorry for that, we do not found an effective solution.

You could go to https://powerbi.microsoft.com/en-us/support/ ,scroll down and click "CREATE SUPPORT TICKET" for further help if you are a pro user.

Best Regards,
Eyelyn Qin

[fsim]

same error here. Did someone opened a ticket ?

[v-eqin-msft]

Hi @masmus ,

The available authentication methods:

• Anonymous: Select this authentication method if the web page doesn't require any credentials.
• Windows: Select this authentication method if the web page requires your Windows credentials.
• Basic: Select this authentication method if the web page requires a basic user name and password.
• Web API: Select this method if the web resource that you’re connecting to uses an API Key for authentication purposes.
• Organizational account: Select this authentication method if the web page requires organizational account credentials.

1.What's your data source?

2.Did you try another authentication method?

3.If your PBI is the latest version, how about rolling back to an older one?

Please provide more details to help us clarify your scenario.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[masmus]

1. SharePoint/OneDrive personal Onedrive files.

2. We have tried all methods.

3. Roll back did not work.

When we tried connecting local data source Onedrive it works perfectly, but when connecting to web-source the same error occurres.

[xmachinex]

same issue here 😕