Converting SSRS Reports to Power BI

Hi bfry24, 

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to divyed, lbendlin,  for those inputs on this thread.

You are on the right track here the error is happening because Z_LastQBUpdate is an SSRS dataset name, and Power BI doesn’t recognize dataset names the same way. Instead, you need to reference the actual table name from your model. From your screenshot, the Date field looks like it belongs to Z_GeneralData, so updating your measure to use that table should resolve the issue.

You can try something like:

Last Update Date = MAX('Z_GeneralData'[Date])

(and use MIN instead if you specifically need the earliest date). Then, to display it like an SSRS textbox, just place the measure in a Card visual, or create a formatted version if you want text along with the date. Once you switch from dataset name to the correct table name, it should work as expected

Hope that clarifies. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.