Make Power Query use filter on expanded Entity on Odata API
Hi, I'm using Power Query to import data of my OData API into Excel and Power BI. Filtering works as expected for base query, for example, querying an entity set called "Address" and filter following a parameter called "city" work very well. I see in the log of my API that a url with the following argument : "http://myservice.com/odata/v4/Address?$filter=city = 'Paris'" is generated. But, when I'm using an expanded table and I'm using a filter on a field of the expanded table, it's not working as expected. For example, I expand the entity set "Country" of the entity set "Address" and then I filter the country by name the url generated is "http://myservice.com/odata/v4/Address?$expand=Country" there's no filter all seems to be done thought Excel. I expected something like this "http://myservice.com/odata/v4/Address?$expand=Country($filter=name eq 'France')". I need this, because, there's a huge amont of row in my expanded entity set, and filtering is mandatory for user in order to get data. If anybody could help me adapt my API or this a parameter to enable filtering on expanded table, I'll gratefull.From Take-Off to Landing - 6 Steps to a Successful Microsoft Teams Pilot
Your journey to Microsoft Teams can be turbulence-free with the right planning! Join experts Dux Raymond Sy and Microsoft's Michael Gannotti as they walk you through the steps during your pilot take-off, flight, and landing! Register for the webinar and more in this week's SharePoint newsletter: http://bit.ly/SPFestNewsJan23 Join us at SharePoint Fest DC 2020: www.sharepointfest.com/DCPower BI and Azure Data Catalog
Your Organization already has a data catalog for use in Power BI, By Proceeding you will associate this Catalog with your Azure subscription, Your catalog will be named 'catalog' and will be located in the northeurope Azure region I keep getting this message however when i try to search for the catalog being used with Power BI i am not able to I have tried using Power-BI admin portal it created a new login and free trial for me Still i am not able to see it anywhere neither in Azure nor in office 365
Best 365 solutions for the following...
Hi, I currently have a number of automation tasks I would like to build solutions for and I'm wondering whether they can be built entirely in the 365 software range (PowerBI, Flow, Sharepoint, PowerApps) (I'm a new user). To give a couple of examples: Task 1: 1. Pull csv file 1 from an FTP server 2. Apply some data transformations to a locally stored csv/database file 2 based on file 1 (e.g. appending, groupby) 3. Save the updated file 2 4. Execute API instructions (upload data based on file 2) 5. Run this task automatically on a weekly basis. Task 2: 1. Triggered via a new email into outlook - microsoft exchange account 2. Run this email against a locally stored machine learning model (the model is already built), which returns category data. 3. Based on this cateogry data, move the email into another folder within outlook. Task 3: 1. Pull data from an SQL server 2. Pull data from an API 3. Do some data manipulation 4. Use this report to generate an email report or dashboard 5. Execute this daily I know I can achieve all of the steps in python, but I'm looking for something more robust using 365 software. I've had a quick look at PowerApps, but that looks more geared towards apps with user interaction.? Where would be a good starting point for fully automating these tasks using 365 software? Thanks in advance,Internal error: An unexpected error occurred
This problem has been bothering me for a long time. When I use the Analyze in Excel feature in Power BI and open the downloaded files in Excel, I get the following error. I am sure that it is set up correctly in Power BI. This problem appears suddenly and exists for all reports. My excel version is 2016. And when I want to connect directly from Excel to Power BI, I can't find the Power BI data source and I don't know if I have wrong somewhere. I didn't find a solution online and I hope someone can help me, thanks in advance.
PowerBi online connect to dataset of Sharepoint online List
Hello, I created a sharepoint online communication site and after add through an import from excel file a sharepoint online list item. I would like from PowerBI online to connect to this list and create a report. After add this report on my sharepoint online site homepage. I cannot connet with PowerBI online whilst using Power BI Desktop i found the datasource didcated for sharepoint list but in this way I cannot link the report on my sharepoint site. What could i do? Any suggestions? Thanks Regards
