Forum

Hi William, I'm a bit confused by your description. Each query links to a single data source and then puts the final query result either into anoth...

Hi Claudine, No file attached. Be sure to click 'start upload' and wait for the grey check mark beside the file size before clicking submit. Myn...

Hi Paul, Not sure there's a better way to isolate cell G4 that what you've probably already done. When you 'close and load' choose Connection On...

Hi Claudine, You have two tables in your model with the same names: one called Group Settings and another called Group_Settings. Your PivotTable is...

Hi Paul, Create a new query to get the data from cell G4, then add a column to the original query =#"New Query Name" Mynda

Hi Laura, Welcome to our forum! Your merge query will be triggering all the individual queries to make another call to the website, as explained he...

Hi Claudine, I've not experienced this error before, however fellow Microsoft MVP Sergei Balkan wrote this post on the possible causes. I hope that...

Hi Michael, There's no refresh settings in Power BI Desktop as this app is intended for your design process. You'd need to publish the report to th...

Hi Paul, Is the network folder a SharePoint folder? If so, the connector is different. If not, then you can edit the M code via the advanced editor...

Hi Donna, I had a few minutes spare, so I created the date table and measure in your file, see attached. Note that you need to use the Date fields ...

Hi Alma, It's great to hear you found my tutorials helpful 🙂 I'm confused whether you're referring to the old query connector or Power Query. ...

Hi Donna, Thanks for clarifying. You want to see an aggregated view of the data and for that you need the time intelligence functions, which requir...

Hi Max, My bad, I misread your request. For the summary table you will have to use a formula like the one below: =SUMPRODUCT(SUBTOTAL(3,OFFSET(N...

Hi Mattias, The Dayorder columns should be in your Date table along with name of day and week of year. You can then connect your DateAndTime15Min t...

Hi M, Welcome to our forum! I recommend you use Power Query to find partial text strings. Hope that points you in the right direction. If you ge...