Forum Discussion
Incremental Refresh Power BI
- 4 years ago
No prob. Glad to help. If anything I have said helps, please "accept as solution" for that part so this thread can be known to be solved.
You can't. A List is a Power Query object, not a SQL Server object, so nothing to send back. But you may still do this if you use it correctly. See this article.
I generate a list. It can come from anywhere. Then I pass that list to List.Contains in SQL Server via a Table.SelectRows() function. It folds using the in operator.
I tried what was mentioned in the document but it created an error. I will be needing a List date in order to calculate the measure. Can you please share what you did to create the list of dates using that documentation?
- edhans4 years agoCommunity Champion
Put this in a blank query.
let Source = {Number.From(#date(2021,1,1))..Number.From(#date(2021,12,31))}, #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), {"Date"}, null, ExtraValues.Error), #"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Date", type datetime}}) in #"Changed Type"that will give you a list of dates in the datetime format from Jan 1 to Dec 31 of 2021.
But I honestly don't see what a list has to do with a measure. Lists are in Power Query and do not load to the data model. They get stripped off.
I think you are way beyond what is needed for incremental refresh.
I suggest you ask different questions for measures in the DAX forum and just focus on getting incremental refresh to work here.
If you are still having issues with Incremental Refresh, please ask a comprehensive question on your specific issue. All we have are bits and pieces. Remember, we don't have your PBIX file, nor understand your data, so partial questions only delay a good answer. We are about 10 posts deep here already and no solution.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables. - Nepal1014 years agoHelper III
Thank you for the suggestion. I will be doing that I truly appreciate your reply as I am new to this forum and tool.
- edhans4 years agoCommunity Champion
No prob. Glad to help. If anything I have said helps, please "accept as solution" for that part so this thread can be known to be solved.