Customers who want to consume Dynamics NAV data with OData in Microsoft Excel and have company names such as CRONUS A/G or CRONUS Danmark A/S may find it difficult or result in an error. When connecting to an OData feed from Excel, this does not work unless you don’t specify a Company Name in the connection string and set the company as a “Services Default Company” on the Dynamics NAV Server instance.
Tag Archives: URL
Using Html.Table() To Extract URLs From A Web Page In Power BI/Power Query M
Last year I blogged about how to use the Text.BetweenDelimiters() function to extract all the links from the href attributes in the source of a web page. The code was reasonably simple but there’s now an even easier way to solve the same problem using the new Html.Table() function.
Downloading pdf file from HTTP URL
In some cases we need to download PDF files from HTTP URL’s, below are two functions that can be used in Navision to download a PDF file from HTTP URL’s (which does not require authentication).
Using Text.BetweenDelimiters() To Extract URLs From A Web Page In Power BI/Power Query M
The Add Column By Example functionality that appeared in the April 2017 release of Power BI Desktop is, I have to say, very cool: I’ve used it quite a bit in the last few weeks and it really does work well. One thing I noticed while using it is that three new functions have been added to the M language to support this feature:
Passing filters to Power BI reports using the URL / query string
It was only recently that I discovered this – you can pass filters to Power BI reports by deep linking to it and adding a filter in the URL (also called query string). I am not even sure this is a feature, since it only seems to work for ‘equals’ and does not work on Dashboards in Power BI.
NAV 2015 – Use Email with Company Logo and URL
In today’s article we will try to add two things on the Email send from the Navision –
1.URL of a website.
2.Company Logo in Email Footer.
NAV 2013 & NAV 2013 R2 – How to – Using FlowFilters in OData URIs.
The Example shown below is from NAV 2013 R2 and using a Page web Service. The Steps remain same for Query Web Services and in NAV 2013.
In this procedure, we will create and publish a web service from the Item Card page in Microsoft Dynamics NAV and then query the data in that web service by using a FlowFilter.