Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
wjbreitenbach
Frequent Visitor

Dynamic subscriptions for paginated report - Parameters greyed out

I am setting up a dynamic subscription for a paginated report following the steps outlined in Dynamic subscriptions for paginated reports (Preview) | Microsoft Power BI Blog | Microsoft Power BI.

I am able to set Recipients, Email subject, and report format. However, when I get to the Parameters page in the set up, I cannot select "Get from data". It is greyed out. How do I enable the parameter to get data from the table?

 

wjbreitenbach_0-1695398284634.png

 

wjbreitenbach_1-1695398301567.png

 

1 ACCEPTED SOLUTION
wjbreitenbach
Frequent Visitor

I figured out the issue. The parameter must be TEXT data type in the Power BI Report Builder. It was a INTEGER since the FacilityID was a number. Once I changed it to TEXT, the Get from data option was enabled. Hopefully in the future, it will allow data types other than TEXT.

View solution in original post

1 REPLY 1
wjbreitenbach
Frequent Visitor

I figured out the issue. The parameter must be TEXT data type in the Power BI Report Builder. It was a INTEGER since the FacilityID was a number. Once I changed it to TEXT, the Get from data option was enabled. Hopefully in the future, it will allow data types other than TEXT.

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.