Direct Query Cannot Load Model Login Failed for user The exception was by raised by the IDbConnect

0 votes
Hi there

I have built a PBI desktop report in Direct Query Mode. The report is working fine for me.  The issue I have is that a colleague, who could access the PBIX file a week ago, cannot access it now. He can however access the published version. But I need him to be able to access the PBIX file to make changes. He can also access the DB and table in SQL and write a query against it.
Nov 15, 2020 in Power BI by anonymous
• 10,480 points
547 views

1 answer to this question.

0 votes

The current power bi pbix file connection credentials are stored locally.
Therefore, it means that it will prompt you to update/verify the data connection credentials if you send or download the pbix file directly and use it on another device or display the error message for any valid credentials to obtain and connect to the database.
Note: You are working in the direct query mode that will send the query each time you interact with visuals or load data. The import mode data source, allows you to make some report layout changes to the pbix file if it does not operate on the backend query tables.

I hope this will help you know more about your scenario.

answered Nov 15, 2020 by Gitika
• 65,930 points

Related Questions In Power BI

0 votes
1 answer

Power Query Web request results in “CR must be followed by LF” Error

What I think is, it might look ...READ MORE

answered Oct 29, 2018 in Power BI by Shubham
• 13,480 points
708 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
1,504 views
0 votes
1 answer

Power Query: Split Column by field lengths

Start by creating a query with the ...READ MORE

answered Jan 30, 2019 in Power BI by Upasana
• 8,620 points
1,147 views
0 votes
1 answer

Difference between the number of days user(client) has logged into the website.

Hi Rajesh, Use below code -  Column 4 = ...READ MORE

answered May 9, 2019 in Power BI by Cherukuri
• 32,990 points
104 views
0 votes
1 answer

Install Power BI Desktop

It’s a pretty simple process. All you ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,370 points
255 views
0 votes
1 answer

Few tips before I start creating Power BI dashboard

It’s always advisable to begin with the data ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,370 points
207 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,370 points
281 views
+1 vote
1 answer
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,480 points
24,263 views
0 votes
1 answer