2/12/2023 0 Comments Online app builder odata feed![]() ![]() The final dashboard looks like as shown below: ![]() In the same way, I have added different shapes with different data representation. I have changed the visualization to Card type. When you click on the report icon it will show all the four tables with its columns in the “Fields” section as shown below:ĭrag the total sales column from the Company Sales table and insert into the report which will automatically create visualization as shown below. This also allows an option to create new relationships between the tables. When you click on the small arrow between the tables, it will display the relationship between the tables. Relationships view will display the relationship between the tables. ![]() New column, rename the columns, delete unwanted columns, hide columns from report view. When you click the table icon, it will display the tabular view of all four tables selected from ODdata feed where you can create a new measure, Once the data is loaded you can see the data and relationships icon in the left side of the designer is enabled. Select all the tables and click “Load” which will load the data, connection in model as shown below: I have used the Adventure Works OData feed from Microsoft:Įnter the URL and click OK which will connect to the data and show the data in the tree view as shown below: ![]() It will show open a popup window where you can enter the OData Feed URL as shown below: Open the Power BI desktop -> close the initial startup page -> click Get Data -> OData Feed Creating Reports using OData Feed in Power BI ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |