Converting SSRS Reports to Power BI

[bfry24]

With SQL Server 2025, Reporting Services is deprecated and now using Power BI.

I am new to this, but created my first report.  The only problem I am running into it a couple expressions used in the SSRS and converting them to DAX.

This is the Expression in SSRS:

This is the fields in Power BI:

Any suggestions on how to do this?  I want it at the end of a Text Box.  Can it added as the Value of the text box or a separate Measure?

[v-kpoloju-msft · Accepted solution]

Hi @bfry24, 

Thank you for reaching out to the Microsoft fabric community forum. I reproduced the scenario, and it worked on my end. I used it as sample data and successfully implemented it.

outcome:

I am also including .pbix file for your better understanding, please have a look into it.

Hope this clears it up. 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

[v-kpoloju-msft]

Hi @bfry24, 

Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

Thank you.

[v-kpoloju-msft]

Hi @bfry24, 

Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.

[divyed]

Hello @bfry24 ,

You need to convert all expressions to measures or calcluated column based on your requirements while converting ssrs reports to power bi. In your case a simple measure with min( your field) will be enough but you can convert additional expressions as well. For example you can use dax measure for conditional colorings ( background and font) , hide and show fields etc.

I hope this helps.

Cheers.

[lbendlin]

as a measure:

MIN('Z_LastQBUpdate'[Date])

[bfry24]

This is what I get:

Again, I am very new to Power BI

[v-kpoloju-msft]

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.

[v-kpoloju-msft]

Hi @bfry24, 

Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

Thank you.

[bfry24]

Appreciate the assistance.

I used the measure in a text box, but instead of display the date, I get the following:

Last Quickbooks Update: DateLastUpdatedFromQB