Allow inclusion of our set of providers with online version
We have created a power bi driver for over 50 platforms, both open data (free version) as premium platforms. However, only runs on desktop edition. It even supports access to on premise platforms from the online version through our own tunnel, but we seem not able to find information whether it i...
Honor ETag or Cache-Control to reduce OData network traffic by an order of magnitude, including developer experience
In this idea, I will explain how Finance and Data Professionals can experience a significant improvement in their productivity when Power BI Desktop would honor the ETag or Cache-Control headers of OData feeds. The idea also explains how the quantity of avoidable network traffic for OData can be...
Differentiate error for OData 4.02 behavior: "We expected a property ‘...’, but the OData service omitted it from the response data."
The error at the end can be returned when occur when the OData server leaves out the value assignment of null to fields defined in the metadata.
However, starting OData 4.02, the same error can also occur when the OData.Feed specifies that the server may leave out null values ...
Optimize OData4 query removing duplicate OR-clauses, remove superfluous filters and using IN.
Power BI does not optimize the OData4 query when filtering on a number of values for a field. For example, it is not uncommon that identical filters are added multiple times with the OR-operator, required fields compared with null and an OR-operator used when IN could be used.
Centralize maintenance and higher default Timeout on OData
The default timeout of OData feeds is 10 minutes. However, large sites typically have downloads on our OData-producer that exceed that by large. The Power BI error due to a timeout is vague and does not guide the user to a solution by providing a hint or suggestion. Currently, we must train ev...
Reduce download size by central setting omit null values in HTTP Prefer header
The OData4 standard allows null values to be omitted. However, this HTTP Header is not set by default. We must train every user (thousands of companies) to change the OData.Feed everywhere.
It would be great when the HTTP Prefer header would be set always or when that could b...
Increase scaleability by fixing OData "An existing connection was forcibly closed by the remote host."
For OData4-downloads, users experience great reliability when using Power BI Desktop. When the same load is moved to Azure Data Factory, it also works great. However, with larger datasets (starting at 10 MB), OData-downloads intermittently fail with the error:
Data so...STATUS DETAILSNew
Extract OData error from OData, even when HTTP Streaming is used by OData producer
Most OData-producers use HTTP Streaming to start shipping data to the OData-consumer as early as possible, allowing the consumer to process the data while more is being generated to reduce runtime duration as well as memory footprint across all stages.
However, when the produc...