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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
DidiermaFR
Frequent Visitor

DATAMART: unable to use Power Query Online parameter in a datamart

Hi folks,

I wanted to use power query online parameter in a Datamart to help users choose their language in an international report from the POWER BI Datamart.

I entered a list of languages in a parameter list, and a parameter choice in Power query Online. But then, neither list or value is  to be seen from the datamart user : no table, no value is reachable, the PQ parameter seeems to be seen only from PQ on line but not from Datamart users or reports from Datamart. 

2 ACCEPTED SOLUTIONS
GilbertQ
Super User
Super User

Hi @DidiermaFR 

 

I do not think it currently is possible to pass parameters to the datamarts at this point in time. It is currently in preview so it is not 100% completed.

 

You can vote for ideas at https://ideas.powerbi.com





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

DidiermaFR
Frequent Visitor

Considering this predecament, I suggest to create a  table of languages in the Datamart. Report Designers will be able to use a slicer from this to make the choice, and DAX SELECTEDVALUE will do the job to take this choixe into consideration.

thx for your help

View solution in original post

2 REPLIES 2
DidiermaFR
Frequent Visitor

Considering this predecament, I suggest to create a  table of languages in the Datamart. Report Designers will be able to use a slicer from this to make the choice, and DAX SELECTEDVALUE will do the job to take this choixe into consideration.

thx for your help

GilbertQ
Super User
Super User

Hi @DidiermaFR 

 

I do not think it currently is possible to pass parameters to the datamarts at this point in time. It is currently in preview so it is not 100% completed.

 

You can vote for ideas at https://ideas.powerbi.com





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors