Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
YacinO
Regular Visitor

Dynamic data source for Power BI SERVICE

‎06-19-2024 04:57 AM

For the use of my dashboards in Power BI Service, I need to vary my data source based on selection in a column. I've tried setting up a parameter to vary the data source based on the slicer selection of this variable, but I'm struggling with the M language solution. Also I don't even know if its possible for a client to select the variable and to refresh in live the dataset in Power BI Service. My data sources are xslx files.

 

 

Thank you in advance for your help!

Labels:
Message 1 of 4
775 Views
0
2 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User

‎06-19-2024 08:57 AM

Dynamic M Query parameters only work with Direct Query data sources.  Your xlsx files are Import Mode only.

View solution in original post

Message 2 of 4
744 Views
YacinO
Regular Visitor
In response to lbendlin

‎06-27-2024 01:54 AM

Thanks, so its possible for the user in power BI Service to change the sources in live if its direct query data sources ! 🙂 

 

Thanks for your answer

View solution in original post

Message 3 of 4
678 Views
0
3 REPLIES 3
lbendlin
Super User
Super User

‎06-19-2024 08:57 AM

Dynamic M Query parameters only work with Direct Query data sources.  Your xlsx files are Import Mode only.

Message 2 of 4
745 Views
YacinO
Regular Visitor
In response to lbendlin

‎06-27-2024 01:54 AM

Thanks, so its possible for the user in power BI Service to change the sources in live if its direct query data sources ! 🙂 

 

Thanks for your answer

Message 3 of 4
679 Views
0
Anonymous
Not applicable
In response to YacinO

‎06-24-2025 06:25 AM

Hi @YacinO, I know this is a late reply but, were you able to get it to work (reference dynamic sources in PBI service)?

Message 4 of 4
361 Views
0

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All