OData Credentials- Couldn't connect msg
Hello, Could you please help me with the below Issue, When I connect to the OData feed from Power BI Desktop, I can connect, import data, and create reports. OData URIs Example: https://localhost:7048/BC230/ODataV4/Company('CRONUS International Ltd.')/Customer?$filter=City eq 'Miami' 1- If I don't specify the /Customer?$filter=City eq 'Miami' (bring only Customer and apply a filter or select only needed columns in the OdataFeed using $filter and $select) I don't get any refresh problems when publishing the report in Power BI Report Server, Data Source credentials connect successfully and I can create a scheduled refresh. 2- I only get the below problem after adding /Customer?$filter=City eq 'Miami' When I publish the report to our internally hosted Power BI Report Server,I get a red x Couldn't Connect with the following message Here I am Using the same credentials, as in 1- However, I can create a scheduled refresh and the report does refresh successfully(Status=Completed Data Refresh). Note: I am connected to Microsoft Dynamics 365 Business Central What do you think the problem is? a Bug in Power BI Report Server or a setting in BC?
Filter Power BI Report embedded in a web application from Power BI Report Server
Good morning everyone, I am working on embedding and filtering Power BI report hosted from Power BI Report Server. I have successfully been able to embed Power BI report from web application using: <iframe src="http://PowerBIReportServer?rs:embed=true"></iframe> Along with this I also wanted to show report data based on the user has logged in, which I have been able to achieve using: <iframe src="http://PowerBIReportServer?rs:embed=true&filter=TableName/ColumnName eq 'Value'"></iframe> But using this method one user is able to see data of other user by editing the data in the browser. Is there any secure way of doing the filtering for Power BI reports hosted on Power BI report server?
Issue with Oracle connection
Hello everyone, I have a Oracle database as a data source for my report, in my power bi rs desktop version I can refresh data but when I try to deploye my report into the portal for power bi report server I got this error message : An error happened while reading data from the provider: 'Object refrence not set to an instance of an object' I create a data source in the portal just to be sure if the connection between the portal and database it's working well, and effectively it's working successfully. Do you have please any ideas about this topic ?
