Unable to Connect to import or direct query reports

0 votes

Opened BI this morning and am getting "Unable to Connect" error with not further details. Pretty much useless.

2016-10-21 15_45_21-Untitled - Power BI Desktop.png

The gateway is still up and running and data is refreshing online which is great.

I have tried reinstalling BI desktop, signing out, signing in with different users, attempting to create new import and direct query reports all no good.

When opening a direct query file that I have previously created I get
2016-10-21 10_57_16-BD Log - Forest Management Live - Power BI Desktop.png

I can get through to the report but unable to refresh the data or acutally do any modelling.

When trying to refresh a Power BI Direct Query file I get the below error.

Nov 20, 2020 in Power BI by Roshni
• 10,520 points
1,102 views

1 answer to this question.

0 votes

Check your cached data sources. Once in a while, it seems like these can go bad, or a change somewhere to password or configuration impacted them.

You can edit or remove your cached data sources by going to File - Options and Settings - Data Source Settings - click on "Global Permissions" highlight the data sources that are affected and either update them or delete them and reconnect. This should resolve any connection error as long as all the permissions are there.

answered Nov 20, 2020 by Gitika
• 65,890 points

Related Questions In Power BI

+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 52,350 points
1,620 views
0 votes
0 answers

What tools or techniques do you use to validate and clean Power Query code to prevent data refresh failures?

What tools or techniques do you use ...READ MORE

1 day ago in Power BI by Evanjalin
• 2,560 points
16 views
0 votes
0 answers

What debugging tools or methods do you use to pinpoint and resolve DAX or Power Query coding errors?

What debugging tools or methods do you ...READ MORE

1 day ago in Power BI by Evanjalin
• 2,560 points
19 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 22, 2018 in Power BI by nirvana
• 3,130 points
2,698 views
0 votes
1 answer

Solving an error in my report query.

This situation typically happens when you have ...READ MORE

answered Nov 20, 2020 in Power BI by Gitika
• 65,890 points
680 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,350 points
998 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,350 points
864 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,350 points
1,210 views
0 votes
1 answer

How to change import mode to direct mode of connection in powerBI

Create a new file connect in import ...READ MORE

answered Oct 29, 2020 in Power BI by anonymous
• 65,890 points
1,032 views
+2 votes
3 answers

How to replace null values with custom values in Power BI(power query editor)?

Hi Nithin, To fill or replace the null or ...READ MORE

answered Mar 8, 2019 in Power BI by Cherukuri
• 33,030 points
159,379 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP