Forum Discussion

gk2go's avatar
gk2go
Helper III
6 years ago

Append OneDrive worksheet tables dynamically

I have a worksheet with multiple tables, with a new one added each day. Importing the worksheet In Power BI Desktop conveniently appends all the tables in the worksheet into one table named after the...
Need Help
gk2go's avatar
gk2go
Helper III
6 years ago

Voted!

 

It's the same in dataflows, but there you can edit the query to consolidate all the Tables into one with this code:

Source = Excel.Workbook(Web.Contents("https://sharepoint.com/sites/GK/Shared Documents/Workbooks/data.xlsx"), null, true),

#"Filtered Rows" = Table.SelectRows(Source, each Text.StartsWith([Name], "Table")),

#"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows", {"Data"})
v-joesh-msft's avatar
v-joesh-msft
Solution Sage
6 years ago

Hi gk2go ，

Yes, it’s just that there will be a refresh limit of 8 times a day. Maybe you need Power BI Premium licensing, if the dataset resides on a Premium capacity, you can schedule up to 48 refreshes per day in the dataset settings.

Best Regards,

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

  • gk2go's avatar
    gk2go
    Helper III
    6 years ago

    Indeed, or since the data is in OneDrive Microsoft makes it work for free with the OneDrive Refresh, per the idea you posted.