Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi ,
We have data source as postgres in PowerBi Desktop, but i am not able to find this data source on powerbi.com getData option.
Do both of these button (on desktop and powerbi.com) dont serve the same purpose.
Hi @anjaliu,
In addition to @Greg_Deckler's suggestion, you can also import data from postgres database to data model, then import your file into Power BI where a dataset is created. So postgres data is also available in Power BI Service. You can take a look at supported data source in Power BI desktop or service:
Data sources in Power BI Desktop
Data sources for Power BI service
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
@v-qiuyu-msft - Thanks for clarifying, that was poor language on my part that postgres is not available in the Service. The proper language is that you cannot create a postgres connection in the Service, but it is supported for refresh when creating a dataset from a Desktop file. That's what I meant by my statement, but it was worded poorly!
Hi @Greg_Deckler,
Get your point. I'm happy that we have the same opinion.
Best Regards,
Qiuyun Yu
Correct, the Service has a subset of data source capabilities rather than the Desktop. The Desktop has many more data source connectors that are not available in the Service. In contrast, the Service is the only option you have for utilizing content packs.