cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver III
Resolver III

Text file as parameter (ODATA BAse Url)

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,

 

 

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: Text file as parameter (ODATA BAse Url)

@Angel

 

You can create dataset with all table names included. Then you can create a query parameter with this dataset.

 

2.PNG

 

3.PNG

 

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,

 

 

Highlighted
Resolver III
Resolver III

Re: Text file as parameter (ODATA BAse Url)

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


Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors