Forum Discussion
Connect Odata resource from Power BI Services
Hi jhampson,
What OData data source do you connect to? Power BI Service provide content packs for some online OData sources, you can connect to these content packs in Service.
In addition, what is the problem you get after connecting to your OData source in Power BI Desktop? You can create reports in Power BI Desktop, publish reports to Power BI Service and schedule refresh for your dataset in Service.
Thanks,
Lydia Zhang
I want to connect to Microsoft Dynamics CRM online.
I've seen one of the content packs - it creates an SQL server in Azure, a kind of datawarehouse. Thing is.. there are apps for Dynamics in get data, only those apps don't seem to pull any custom data.
Hi jhampson,
Except the Microsoft Dynamics CRM content pack, there is no method to connect to Microsoft Dynamics CRM from Power BI Service. Why not use Power BI Desktop?
Thanks,
Lydia ZhangIf all I use is Power BI desktop I have to keep it on in order to refresh the data. The point is that I want the data to up date on its own in the cloud and not require any onpremise connection to refresh it. I want a SaaS solution.
Now I did discover that when I upload a report created in Desktop to Online my Odata connection to that data source goes with it, and I can schedule a data refresh that way. Only today, however I discovered that my refresh didnt automatically run on its own, due to my personal gateway being offline... ok now need to figure out what that is....
Is my personal gateway my power Bi desktop?
An OData connection to CRM online shouldn't require a gateway at all. I have a dataset connected to our dynamics 365 that updates on a schedule every day and has no gateway involved. Does your dataset include other sources aside from your CRM odata?