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 19, 2020 in Power BI by Roshni
• 10,420 points
108 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 19, 2020 by Gitika
• 65,870 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,310 points
482 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 21, 2018 in Power BI by nirvana
• 3,150 points
1,446 views
0 votes
1 answer

how can I connect my web api with Power BI Reports?

Go to Home > Edit Queries > ...READ MORE

answered Oct 18, 2018 in Power BI by Annie97
• 2,200 points
6,389 views
0 votes
1 answer

Error:connecting to Azure SSAS server in Power-BI through Import mode

If I understand correctly, you're connecting to ...READ MORE

answered Nov 9, 2018 in Power BI by Upasana
• 8,620 points
1,143 views
0 votes
1 answer

Solving an error in my report query.

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

answered Nov 19, 2020 in Power BI by Gitika
• 65,870 points
54 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,310 points
227 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,310 points
184 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,310 points
233 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,870 points
117 views
+3 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
• 32,930 points
54,665 views