Jorge Segarra on 05 Mar 2017 04:20:15
Office data connection (odc) files allow end users to quickly and easily launch , create a pivot table connected directly to a specified data source. I propose a Power BI data connection (PDC) file that had similar behavior. This would allow easy publishing access to data sources in enterprises so end users that wish to author custom reports against data sources don't need to jump through multiple steps to access data source. The PDC file would launch desktop tool and connect directly to configured data source in one step.
- Comments (15)
RE: ODC equivalent for Power BI Desktop
this exists today as a .pbids file: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources#using-pbids-files-to-get-data
RE: ODC equivalent for Power BI Desktop
I agree, this would be very helpful. We also need to be able to add the odc to the excel data model
RE: ODC equivalent for Power BI Desktop
I guess that the File > Import > Excel workbook contents feature may partially close this gap, in particular, connect Power BI to a Power Pivot Data model.
RE: ODC equivalent for Power BI Desktop
Please Microsoft! Conection with .ODC
RE: ODC equivalent for Power BI Desktop
Yiou must !
RE: ODC equivalent for Power BI Desktop
PLEASE!!
RE: ODC equivalent for Power BI Desktop
Yes
RE: ODC equivalent for Power BI Desktop
For easier maintenance of multiple worksheet templates using server-based ODC queries, I would very welcome to have an exernal editor for these ODC files - or better: to have full SQL-support and XML-format compliance, so any editor "understanding" these formats could be used :)
RE: ODC equivalent for Power BI Desktop
Yes please
RE: ODC equivalent for Power BI Desktop
Definitely a great time saver!