Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
techgirl
Frequent Visitor

Network drive - 'unable to connect to data source undefined' error

Hey all,

I've been struggling with the error message in the screen shot below (please excuse the mix of Norwegian and English) since the beginning of the year. 

For context: I'm working with a client that uses a network drive for shared organizational files. I use some of those files as data sources in my Power BI model, but I need to change what file I am using once a year. For example, one of the files is a yearly budget in Excel, and a new one is prepared every December. Then it is regularly updated throughout the year (i.e., several times a week). 

 

As expected, in the beginning of January I had to change which file I am trying to connect to in Power Query. I did so, using a parameter to switch between the use of IP address in Power BI Desktop and server name in Power BI Service (the network drive is located on an on-prem server). Unfortunately I started seeing the below error message when I tried updating my dataset, and soon after my scheduled refresh stopped working. This is detrimental to my report because it is crucial for my client that the data is as up-to-date and "live" as possible (8 refreshes per day) - which it's not right now.

 

Can anyone help me with this? I'm using a Power BI Gateway which has been updated to the latest version (Dec 2020). Neither the server nor the files I'm trying to access have moved or been renamed. The privacy level settings should also be the same in both Desktop and Service -- and that's all the tips I've been able to find on Google so far.

 

Error message in Power BI ServiceError message in Power BI Service
EDIT: When scheduled refresh is working, my report actually seems to be displaying new data as expected. However, the problem arises when scheduled refresh stops working.

1 ACCEPTED SOLUTION
techgirl
Frequent Visitor

Hey, @v-easonf-msft 

I got it to work by switching from using the Folder connector to using the Excel connector in Power Query instead. I also re-entered my credentials like you suggested. Thanks!

View solution in original post

8 REPLIES 8
techgirl
Frequent Visitor

Hey, @v-easonf-msft 

I got it to work by switching from using the Folder connector to using the Excel connector in Power Query instead. I also re-entered my credentials like you suggested. Thanks!

techgirl
Frequent Visitor

@v-easonf-msft - thanks, but I've just checked, and everything works fine on Power BI Desktop/Power Query. That goes both for my original pbix file and when I download the report from the service. I'm only seeing the error message in the web portal. However, when I try to re-publish my report to the Power BI Service, my visualizations are showing new data as expected even though I still see the error. What I need help with is ensuring scheduled refresh starts working again, as now it's disabled after 2-3 refreshes fail.

PS: For clarification I am keeping my data model and my report with visualizations in two separate pbix files. I am using the Power BI dataset connector in my report, in order to keep it up-to-date with the newest data.

Hi , @techgirl 

If you did not change the excel file and everything is normal when you refresh the report on the desktop, I will suspect that your excel credentials in the gateway have expired. You may need to re-enter your data source credentials, even if it  seems to be working fine.

34.png

 

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

aj1973
Community Champion
Community Champion

Hi @techgirl 

The Gateway is somehow sensitive to manual changes every now and some mismatch can occure down the path. I suggest that first you update your Gateway, Publish your report into a new workspace and use the Gateway to manually refresh it. If all is good then check by elimination what is going wrong in the previous Workspace and correct it if you still want to use it.

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

v-easonf-msft
Community Support
Community Support

Hi ,  @techgirl 

I agree with @collinq , this error mostly occurs when the structure of the original data source does not match the structure of the report model ( therefore cannot access the corresponding data).

You can  download the report from the service and   refresh  it on PowerBI Desktop to find more error message.

 

Best Regards,
Community Support Team _ Eason

techgirl
Frequent Visitor

Thanks, @aj1973. How do I check which credentials the gateway is using to connect to my Excel file? As far as I know I'm using the same credentials I've used before - that is, the credentials to the network drive. Those would not have changed since I last tried to connect to other similar files in the drive.

collinq
Super User
Super User

Hi @techgirl ,

 

This is commonly an issue of "something is different" .  As in, an extra field, or, more likely a deleted or renamed field.  here is more lenghty explanation of this issue: Chris Webb's BI Blog: Understanding The “The key didn’t match any rows in the table” Error In Power ...

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




aj1973
Community Champion
Community Champion

Hi @techgirl 

It's more likely the Gateway can't find the right credential to connect to the table "Budjett PW 2021.xlsx". 

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors