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…

Avoiding Duplication Of Database Connection Information In Power BI

In a year’s time there will be a great opportunity for someone to present a session on “Power BI Development Best Practices” at the PASS Summit. Before then, we will all have to work out what those best practices actually are – probably the hard way. With that in mind, here’s a suggestion for one good practice that came out of a conversation at this year’s PASS Summit (thank you Prathy).

Bron : Chris Webb’s BI Blog
Lees meer…