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
PowerQueryFTW
Frequent Visitor

Can't Get Power BI to Refresh My Power Query

I'm a bit of a newbie and have spent the past few hours trying to search for a solution so any help would be appreciated.

 

I have an excel workbook that has a series of Power Query calls loaded into the data model.  The data model is pivoted and the users in my organization access the tables via excel online.  

 

My current refresh involves task scheduler and vba but from what I'm reading a better solution is refresh on a schedule with powerBI.  The query accesses folders of CSV files and joins them.  

 

I loaded my report into PowerBI, installed an on-premises Data gateway on my always on machine, and setup the gateway successfully.  Wasnt sure what to setup as a data source so i added the file on my Ondrive for business that houses the report, and the folder with the xlsx file/CSV files.  Those added successfully.  However when I log into PowerBI and hit refresh now, I get an error saying Workbook Refresh Failed and references the first Query.  

 

Not sure what I'm doing wrong or what the next steps are but would appreciate any help I can get. 

 

Windows 8.1

Office 365 enterprise E3 - PowerBI Pro

2 REPLIES 2
v-qiuyu-msft
Community Support
Community Support

Hi @PowerQueryFTW,

 

From your description, it seems that you create a Excel workbook use Power Query connect to local CSV files, then you upload both Excel workbook and CSV files into OneDrive for Business, right?

 

As the CSV files location changed after moving to OneDrive, make sure the Power Query corresponding changed regarding connection string.

 

Reference:
Refresh a dataset created from an Excel workbook on OneDrive, or SharePoint Online

 

Best Regards,

Qiuyun Yu

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

Hi @v-qiuyu-msft,

I have an xlsx workbook with multiple queries each associated to a different folder of csv files.  The files are joined using functions that are invoked as a custom column.  

 

The workbook never leaves onedrive for business but recently I read a thread from 2015 that said powerBI can't refresh queries that are using functions.  Not sure if that is still true or if I even read it right but the error message seems like it.

"You can't schedule refresh for this dataset because one or more sources currently don't support refresh."

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