How To Connect OData Feed and Fix Data Source Credential Issue?

1
Welcome In Loginworks Softwares
2
How To Connect OData Feed and Fix Data Source
Credential Issue?

• Hey friends, in this blog you will learn
  connection of OData feed and fixing the problem
  when you want to connect it using Microsoft Power
  BI. Before going to start in deep, lets first
  know what is ODdata feed in brief.

3
About OData

OData (Open Data Protocol) is an ISO/IEC
approved, OASIS standard that proves a set of
best practices for developing and consuming
RESTful APIs. OData helps you concentrate on your
business logic implementation while developing
RESTful APIs without any problem to worry about
the different approaches to characterizing
request and response headers, status codes, HTTP
methods, error handling, query options, etc.
OData also provides a roadmap for tracking
changes, declaration of functions/actions or
methods for better procedures, and sending
asynchronous/bulk requests to the server.

OData RESTful APIs are easy to use in any
application. The OData metadata is a powerful
mechanism description for developing data model
of the REST, that can enable the creation of
powerful generic client proxies and tools.
4
Connect OData Feed

• Open your power BI desktop, click on get data
  then a window will open for connection. Just
  select All, scroll and select OData Feed as
  showing in the image and click on connect.
• After you click on connect, then a new popup will
  open. Its just a single popup which asks for
  entering URL of Odata. You can put single URL on
  selection basic but if you have broken URL then
  enter in advance. The advance option also
  generates single URL which is entered in multiple
  parts as showing in the image. URL is the same,
  there is no difference between them.

5
I have copied a URL form Odata which is API URL
if you dont get the same URL then click on link
https//www.odata.org/odata-services/ this
redirects on OData services page where you can
get many URLs. To get dummy data just copy and
paste in box and hit OK button after fetching
connecting from the server this returns a result
set.
6
API response was given by server click on the
load button then this generates a table list on
right in Power BI visualization. This response
has some information of people like age, first
name, last name, middle name, username. Now, I
will create the report using this
information.
7
I have created a simple and basic report using
this record which is got by API. From this
response, data was not numeric so I could not
show average, line chart and bar chart. It is a
basic report in which I want to show all list of
gender slicer, first name, last name in treemap
chart, and the feature is showing in the card.
All charts also reflect when we change gender in
slicer, if we select male then it will filter
record of male and so in the chart as well as
female also.
8
OData Credentials Issue

• Data Credential issue is an error which is
  encountered when we want to implement refresh
  scheduler on web power BI. When we click on data
  source credentials then we get this error which
  is shown in the image. This error is encountered
  when the report path is invalid that means report
  path is another system/folder path. So, this is
  not capable to open file because the path is
  invalid. For example, if any report is shared
  with someone then this report will be working
  fine but Microsoft Power BI Experts has saved
  this files local path where the report is
  created but now I am going to solve this problem
  in the next step.
• If you want to learn more about Data Refresh
  Scheduler implementation in Power BI, just follow
  this link https//www.loginworks.com/blogs/how-to-
  configure-schedule-refresh-in-power-bi-reports/.

9
This shows the old path of the file that is not a
valid path of data, it also shows an error which
is in light yellow color. If you dont have that
data on your local machine, then go to tablegt and
right clickgt copy tablegt then paste in xlsx or
xlx and save it. After that browse it with the
same file name. But remember one thing that you
should not change file name, only change file
location and save it. After that, browse this and
press OK button. After the update, publish this
report from power BI desktop in your workspace.
Now go to

Power BI Specialist web refresh scheduler section
then go to edit credential and you will not get
this error.

Summary

In this blog, we have learned connection of OData
feed and how to implement this in Power BI. I
would recommend you to go through the concept of
OData and rest API. And you can also learn the
basic concept of publishing report in power bi
and how to implement schedule refresh.

This is just one topic which I explained to you
and I think I have successfully made you
understand how easy it is to implement this. You
can perform this process on our own and its my
suggestion to try it at least once. For any
query, you can write in the below comment
section. Thanks!
10



Thank You For Watching

Connect with This For More Inf

https//bit.ly/2FL2BvS

Call us 1-434-608-0184