On PowerBi Desktop we can get data using Python Scripts, but after published we can't schedule a refresh data for this connection. The PowerBI returns:
"Query contains unknown funtion name: Python.Execute."
It would be better if all features on desktop would work on web too.144 votes
Please see the gateway section here:
This would have a major impact on organisation old Oracle Essbase envs.9 votes
We’re glad to let you know that the Essbase connector is now Generally Available in Power BI. Please refer to the April release announcement for more details: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2019-feature-summary/
Thanks for your feedback.
Redshift Connector in Power BI Service and Data Gateway really needs to be available soon. Although the release in July enabled Redshift as a Data Source in Power BI Desktop, there is still no update on when this will work in Power BI Service. We now have a strong need to allow for this connection to work in Power BI Service. This must work in Direct Query mode. In addition we should be able to Import Data into the Model and use Data Gateway to Refresh in Power BI Service. That way we can take advantage of the DAX functionality.
This will be a blocker for us using Power BI as our go to BI tool.
Redshift Connector in Power BI Service and Data Gateway really needs to be available soon. Although the release in July enabled Redshift as a Data Source in Power BI Desktop, there is still no update on when this will work in Power BI Service. We now have a strong need to allow for this connection to work in Power BI Service. This must work in Direct Query mode. In addition we should be able to Import Data into the Model and use Data Gateway to Refresh in Power BI Service. That way we can take advantage of the DAX functionality. …68 votes
Amazon Redshift connector is supported end-to-end in Power BI Desktop & Service for Refresh & DirectQuery.
Connector to SAP BW has enabled the easy access to data in SAP BW. However, scheduling the data refresh from SAP BW is not possible since the SSO feature is not available. This would be a good step to create dashboards using Power BI consuming SAP BW data.119 votes
Check https://docs.microsoft.com/en-us/power-bi/service-gateway-sso-overview for more details
Update the SQL Azure connector to use Azure AD Auth. This will allow row level security in the database to be used with PowerBI.
It would be great to have PowerBI pass through user credentials to the database so that data can be kept secure.436 votes
This feature has shipped in the January 2018 update for Power BI Desktop. Please refer to the official announcement for more details: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-january-2018-feature-summary/#AADauth
I have come across so many public data repositories that hold data in PDF format. Other websites have tables within documents such as annual reports etc., also in PDF format. A data source for PDFs or tables from PDFs would be awesome!3,066 votes
The PDF connector is now generally available in the April release of Power BI Desktop. Learn more here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2019-feature-summary/#pdf
It's currently possible to connect to an SAP HANA database from PowerBI Desktop. What we need is a connector from the service to SAP HANA running in the cloud.7 votes
SAP HANA connector is available in Power BI Desktop, including Import & DirectQuery connectivity modes. Reports authored using this connector can be published to the Power BI Service and refreshed via the On-premises data gateway.
The existing oracle data source is extremely slow. I even installed the latest oracle drivers from oracle and that only saw a marginal improvement in speed. My other oracle apps using the same connector are very fast, but Power BI is extremely slow.47 votes
It would be really great to be able to have native support to pull data from SurveyMonkey surveys. There is an API for it after all.577 votes
A SurveyMonkey connector was added in our February update of Power BI Desktop: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2019-feature-summary/#surveyMonkey
Currently the Microsoft Dynamics CRM connector for Power BI contains a dataset (called "Dynamics CRM Sales") that includes a selection of 10 standard CRM entities. While you can create a nice demo of CRM sales analytics with these out-of-the-box records, most customers will not be able to use this for actual reporting on their sales pipeline. This is because pretty much anyone who really uses CRM for managing their sales process will have expanded the data model with custom fields and entities. Right now there is no way to add these into the dataset you get when installing the Dynamics CRM connector.
Sure, I could build a custom dataset with Power BI Designer by referencing the CRM Online OData feed and retrieving the custom entities and fields via this. However, since it is not possible to use the Schedule Refresh feature with these type of datasets that the user uploads to Power BI, that would make the information presented on the Power BI dashboard stagnant. This kind of defeats the whole purpose of Power BI for a Dynamics CRM customer, since the metrics presented would be just the same as on a static Excel workbook, unless someone downloads it to their PC and runs the Power Query data source refresh for the OData feeds.
Since we're essentially talking about a data source that comes from a system built and managed by Microsoft (Dynamics CRM Online), I wonder what the risk would be in enabling the Scheduled Refresh support for OData feeds with the *.dynamics.com URL? This would allow each customer to create the dataset from their customized CRM data model and build dashboards that truly deliver information that their business users are interested in seeing. Compared to the default dataset in the current Connector, there would be essentially no difference in how the data moves from one MS cloud service to another.
Ever since Dynamics CRM Online was launched in 2008, customers using it have been in a disadvantaged position compared to the on-premises CRM server users when it comes to the reporting options available to them (due to limitations with SSRS reporting in CRM Online). What Power BI offers today would seem like the perfect opportunity for MS cloud customers to leapfrog into the next generation of business analytics applications available to power users and not just report developers. The business case for supporting CRM Online in real life scenarios would seem quite obvious to me, and I assume that there must be some plans for making this finally happen. However, until we have something publicly announced by Microsoft, I encourage all the Microsoft Dynamics CRM Online customers to show their support for making this happen by voting on this suggestion here. Thank you!
Currently the Microsoft Dynamics CRM connector for Power BI contains a dataset (called "Dynamics CRM Sales") that includes a selection of 10 standard CRM entities. While you can create a nice demo of CRM sales analytics with these out-of-the-box records, most customers will not be able to use this for actual reporting on their sales pipeline. This is because pretty much anyone who really uses CRM for managing their sales process will have expanded the data model with custom fields and entities. Right now there is no way to add these into the dataset you get when installing the Dynamics…217 votes
Get data from Hyperion Essbase667 votes
We’re glad to let you know that this feature is now Generally Available. Please refer to the Power BI Desktop April release announcement for more details: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2019-feature-summary/
Thanks for your feedback!
Add Netezza as a supported data source157 votes
Thanks everyone for the feedback – We added the IBM Netezza connector (including Import & DirectQuery modes) to Power BI Desktop in the June 2017 release. With the August 2017 release of the On-premises data gateway, the IBM Netezza is also supported via the gateway for Power BI Service Refresh/DQ scenarios.
Enable connectivity to on-prem (or IaaS) SSAS Cubes / multidimensional!1,171 votes
SQL Server on-premise databases are a very big yes-yes1,038 votes
Enterprise gateway only supports SAP HANA and SSAS. Please also make necessary changes to support Teradata.22 votes
This is supported today, it was shipped with the February update
Please add support for ServiceNow (SaaS) as a Data Source. This would be similar to the Zendesk Data Source.520 votes
Hi all – we’re excited to announce the availability of a content pack for ServiceNow Incidents!
If you’re looking for additional features, please vote on the ServiceNow connector in the PBI Desktop (https://ideas.powerbi.com/forums/265200/suggestions/8106117) or add another idea for a new ServiceNow content pack!
using SharePoint lists, alternatively odata feeds664 votes
Support Google BigQuery295 votes
Thanks everyone for your feedback – Google BigQuery connector was added in the Power BI Desktop August 2017 update. Please take a look at the official release announcement for more details: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2017-feature-summary/
Support for refreshing reports that use this connector in Power BI Service is expected before the end of CY17. Stay tuned to the Power BI Blog for further updates on this feature.
Hopefully many of you will have noticed already that we released a content pack for JIRA recently. More details here: https://powerbi.microsoft.com/en-us/blog/explore-your-jira-data-with-power-bi/
We have many Excel files on SharePoint Online Document Libraries - well structured and maintained and refreshed. It would be great to be able to point to those directly. The OneDrive for Business is similar, but it would mean we have to duplicate the files from our existing SPO team site. So it would be great to access Excel files located on SPO team site document libraries.285 votes
- Don't see your idea?