Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

incremental refresh issue questi

Forum home » Delegate support and help forum » Microsoft Power BI training and help » Incremental Refresh Issue Question

Incremental Refresh Issue Question

ResolvedVersion 365

Noemi has attended:
Power BI Reporting course

Incremental Refresh Issue Question

The Issue I have is that this BI file cannot seem to fold the data, as I cannot view the Native query and consequently I cannot define the incremental refresh type and period

- incremental refresh solutions is working on powerbi files that load data using Server IP connection to drive

My questions are:
> is there reason why the data source type (ie csv) or data source location (p drive) and data source import query (csv connection) would not work with data folding for incremental refresh
> if not, are there any fixes I need to do, to be able to finalize incremental refresh?

Here is the situation explained in detailed, on what I have done and where I have an issue

A> I have set the rules, on Desktop version (steps below)
#"Changed Type3" = Table.TransformColumnTypes(#"Duplicated Column",{{"Month - Copy", type datetime}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type3", each [#"Month - Copy"] >= #"Range Start" and [#"Month - Copy"] < RangeEnd),
Where RangeStart = #datetime(2021, 1, 1, 0, 0, 0) meta [IsParameterQuery=true, Type="DateTime", IsParameterQueryRequired=true]
Where RangeEnd = #datetime(2024, 4, 1, 0, 0, 0) meta [IsParameterQuery=true, Type="DateTime", IsParameterQueryRequired=true]

B> I would need next to define values for type of incremental refresh and period, on Spreadsheet view; as per print screen below, this is not enabled for me (issue2)
C> I have checked if BI can fold the data, but I see greyed out View Native Query (issue1)

RE: Incremental Refresh Issue Question

Hi Noemi,

Thank you for the forum question.

Flat files (CSV) do not support data folding.

Please have a look at the link below.


https://learn.microsoft.com/en-us/power-query/power-query-folding

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Tue 7 Mar 2023: Automatically marked as resolved.

 

Training courses

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Power BI tip:

Explore Power BI Templates

Take advantage of Power BI templates to streamline report creation. Templates allow you to reuse custom layouts, themes, and configurations across multiple reports. Create templates for consistent branding or industry-specific reporting standards, saving time and maintaining a cohesive look across your organization's reports.

View all Power BI hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.