Set up Common Data Service connection for Business Central

Today we set up Common Data Service connection for our Business Central environment.

I really appreciate Renato Fajdiga for his blog about this topic but I think I could add more details to that. Also I’m planning additional articles about CDS integration and you’ll need initial setup to start with.

Source : Andrey Baludin
Read more…

Using The “Skip Test Connection” Option For Power BI Data Sources To Avoid Scheduled Refresh Failures

One of the most popular blog posts I have written in recent years is this post on how the RelativePath and Query options for the Web.Contents() M function can be used to allow datasets that use web services as data sources to refresh successfully in the Power BI Service. It’s very frustrating when you write some complex M code in Power BI Desktop and find that your dataset can’t be refreshed after it has been published!

Source : Chris Webb’s BI Blog
Read more…

Setting SQL Server Connection String Properties In Power BI and SSAS Tabular Modern Data Sources

It may not be immediately obvious, but you cannot set your own connection string properties when connecting to SQL Server using the built-in SQL Server connector from either Power BI or a modern data source in Azure SSAS/SSAS Tabular 2017:

Bron : Chris Webb’s BI Blog
Lees meer…