Forum Discussion
Helper IIOData V4 scheduled refresh in Power BI Report server error
Helper IIHello again,
No, in Power BI report server desktop, I am using OData feed because it does support scheduled refresh when saving to the report server.
Does Dynamic 365 Business Central (on-premises) support scheduled refresh when saving to the report server?
https://docs.microsoft.com/en-us/power-bi/report-server/data-sources
Currently, I am using Power BI report server January 2021 version.
My OData Feed URL follow the below structure:
https://demoserver.domain.com:7348/DynamicsNAV110/ODataV4/Company(‘Company%20Name’)/Tablename
I look forward to your reply!
Hi imenmaiza , you probably have this already solved, but as I recently found myself facing the same error I'll post what worked out for me.
Our Business Central app was giving us the ODATAv4 URL like this too:
https://server.domain.com:port/instance-name/ODataV4/Company('Company%20Name')/
This URL worked fine in Power BI Desktop but after uploading to Power BI service we were getting the same error message.
The only solution we've found so far is to change the '%20' back to a space ' ':
https://server.domain.com:port/instance-name/ODataV4/Company('Company Name')/
This URL works in both Desktop and Service
I don't know if it's a known bug, but seems like it's been happening for quite some time
Cheers
Hi Pablo,
I'm facing the same issue and happened to come across your post. I've tried to change the %20 back to a space but it doesn't work for me. Did you change the data source in BI desktop?