Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a custom report that points to a datamart in powerbi. The datamart refreshes daily pulling audits. Long story short, no matter if I point the report at the dataset or datamart, unless I manually go into edit the datamart, save and then refresh the data, the data stops refreshing on the report. See images below. The crazy thing is, in the datamart I can query it and the data is up to date, but even when i hit refresh on the report, it is not up to date. See images below for what I mean.
I have attempted to remove the date filter tool and that also has no effect.
Let me know if you have any ideas or work arounds, thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Wilsonjr ,
From my testing, my report can show the latest data.
How do you connect to your datamart in power bi desktop?
I connect through the following steps, you can refer:
1 click one datamart,select "settings"
2 click "server settings" and copy "connection string"
3 open power bi desktop , and choose "get data-SQL Server", then paste the connection string, choose directquery mode to connect datamart.
Best regards,
Community Support Team Selina zhu