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,082 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,360 points
1,596 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,675 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,160 points
9,545 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
2,616 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
663 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,360 points
966 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,360 points
846 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,360 points
1,187 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,004 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
158,846 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