User Profile
Jackieeee
Frequent Visitor
Joined 2 years ago
User Widgets
Contributions
table.join sort.merge not working since release 092025 on Snowflake
We use the powerquery Table.Join with sort.merge over a longer time. Since last release power query creates a snowflake SQL that is incorrect. The SQL contains a join with itself, makin' it a infinite query on snowflake. Canceling the query on power bi service does not cancel the query on snowflake. Could this be fixed since the table.join with sort.merge is faster?Dynamic Report subscriptions
Hello, I've encounter problems with the filtering a report when using a subscriptions. I've created a report which I like to filter on year. So I’ve created a dynamic subscription. I’ve created a semantic model containing e-mail and outcome. I dynamically defined the e-mail and outcome. So far this goes well. I've received 1 e-mail with a copy of the report in PDF Format as defined. The report shows the results for all the years together which is expected. After I made sure this goes well I've added year to the semantic model and dynamically set the filter on Year. I have defined 3 years. When I run this I receive 3 e-mails but the results are all the same. The filtering just doesn't work. For my setup I've used the following guideline: Dynamic subscriptions for Power BI reports (Preview) | Microsoft Power BI Blog | Microsoft Power BI. What I can't find is the selection box “include my changes”. Why is this setting not visible and is this perhaps the cause of my problem? On the other hand I don't think it is because when I read this guide; Email subscriptions for reports and dashboards in the Power BI service - Power BI | Microsoft Learn it seams that when "Include my changes" is ticked, the state should be "Default". In my case the state is "Default". So I come to the conclusion that the dynamic filtering when using subscriptions for reports is not working. Could you investigate this? I know this function is in preview but we are really looking forward using this function. Sincerely, Jack van de Ven.
