User Profile
bastienmol
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Error when refresh on Bigquery - Incremental refresh
Hi all I have a report, incremental refresh, connected to BigQuery - when I refresh it on desktop all is working as expected. However when I trigger a refresh on service, I have this error. Data source error[ValidateMarkupTags][ccon][ccon]DataSource.Error[/ccon]: [ccon]ERROR [HY000] [Microsoft][BigQuery] (310) Storage API Error: Error: { code: UNKNOWN, message: Stream removed }[/ccon]. [/ccon]. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. But when I deploy the report without the incremental refresh, refresh in service is working in service (so full refresh). Can somebody have any idea what is happening please ? Thanks Bastien470Views0likes1CommentLarge dataset usage optimization
Dear all, I have a large dataset (200m rows) in a report. The refresh part is managed with incremental refresh so I dont have any real issue with that.However the real issue is when the user uses the report and applies a filter, the interface takes ages to be refreshed. I precise I have limited the visuals on the page (only 4), my workspace is under Premium capacity, there is only one table, no calculation and the dataset is setup as large as well. Any ideas what else I could try ? Or enabled ? Reducing the size of the dataset is not really on the table... Thanks Bastien824Views0likes4CommentsRe: Large dataset usage optimization
hi Thanks for your quick response. Something I guess I have forgotten to indicate in my post: there is only one table in the dataset (so no relashionship etc...) there is no calculations (so far) I am basicaly just diplaying the data... That's why it is quite complicated to think and reduice the dataset. Thanks794Views0likes2CommentsRe: Dateadd does not work in DAX in variable
and is there a way to pass a measure, instead of a result ? in a way that I can keep return CALCULATE(me,DATEADD('Daily KPI'[ga_date],-7,DAY)) The reason for this is in reality my formula in more complexe and I call the sales metrics more than once. So the idea was to push it into a variable, then call the variable. thank you again2KViews0likes2CommentsDateadd does not work in DAX in variable
Dear all I have this formula Sales Last Week = CALCULATE(sum('Daily KPI'[sales]),DATEADD('Daily KPI'[date],-7,DAY)) This one is working - it gives me sales for Last Week However when I try this one, it gives me the value as the dateadd is not there. Sales Last Week = var sales = sum('Daily KPI'[sales]) return CALCULATE(sales,DATEADD('Daily KPI'[date],-7,DAY)) Could you please help me to understand why ? Thanks a lot for your helpSolved2KViews0likes6Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.