Forum Discussion

PowerQueryFTW's avatar
PowerQueryFTW
Frequent Visitor
9 years ago

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 in...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

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

  • PowerQueryFTW's avatar
    PowerQueryFTW
    Frequent Visitor
    9 years ago

    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."