Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, everybody
I hope someone can help me with this issue.
I import data to Power BI Desktop using ODATA feed source. This source is composed of two parts: URL Base + Table name.
I have created many reports that use same URL Base but different Table names.
The goal is using a text file for URL Base ODATA. This text file should be loaded into Power BI Desktop as parameter and using the parameter to composed ODATA Feed URL. So, I can avoid to declare same parameter in every report.
Is there any way to do that?.
Thanks in advance,
You can create dataset with all table names included. Then you can create a query parameter with this dataset.
To use query parameter, please refer to links below:
POWER BI DESKTOP QUERY PARAMETERS, PART 1
Dynamic Power BI reports using Parameters
Deep Dive into Query Parameters and Power BI Templates
Regards,
Hi, @v-sihou-msft
Thania for the answer. I didn't know 'add as new query' option.
However, this is not the problem.
I have created many reports. The odata connection is done by two parts. Odata base URL + Table mame.
Report 1: odata base URL + Table 1
Report 2: odata base URL + Table 2
And so On
I want ti write the odata base URL in only one placer that should be used for every report.
Is there any way??
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |