How to set up analytics in Power Bi?

Question

Google Analytics

How to set up analytics in Power Bi? And with which call tracking company can I set up integration?
And another question: in order to collect data on clicks in contextual advertising, do you need to set up integration with Metrica or Analytics, or is it possible with both together?

Answer 1

ringostat if RU, twillio if the world
can be configured with both, but it is clear that Google and Yandex should live with their own

Answer 2

I'm no expert on rv, but when you have to write them, it helps
www.phliveregex.com

Answer 3

(?(?=((?<=\d\s))*)(\d+\s)*)(абв)(?=(\s\d+)*)
Result
This regular expression works only in PCRE (PHP)
ps

<?php
function str_replace_once($search, $replace, $text){
    $pos = strpos($text, $search);
    return $pos!==false ? substr_replace($text, $replace, $pos, strlen($search)) : $text;
}
$st = '123 абв 123 абв абв 123 абв';
$pattern = '~(?(?=((?<=\d\s))*)(\d+\s)*)(абв)(?=(\s\d+)*)~ium';
$flag = true;
$res = [];
do{
    if (preg_match($pattern,$st, $search)){
        $do = !empty($search[2])?$search[2]:null;
        $po = !empty($search[4])?$search[4]:null;
        $st = str_replace_once($search[3] , '', $st);
        $res[]= [$do , $search[3], $po];

    }else {
        $flag = false;
    }
}while($flag);
var_dump($res);
/*
array(4) {
  [0]=>
  array(3) {
    [0]=>
    string(4) "123 "
    [1]=>
    string(6) "абв"
    [2]=>
    string(4) " 123"
  }
  [1]=>
  array(3) {
    [0]=>
    string(4) "123 "
    [1]=>
    string(6) "абв"
    [2]=>
    NULL
  }
  [2]=>
  array(3) {
    [0]=>
    NULL
    [1]=>
    string(6) "абв"
    [2]=>
    string(4) " 123"
  }
  [3]=>
  array(3) {
    [0]=>
    string(4) "123 "
    [1]=>
    string(6) "абв"
    [2]=>
    NULL
  }
}

*/

It turned out that preg_match_all does not support this standard... I had to make such a bicycle... It's very interesting how to make a global search on a string with a regular expression that looks forward and backward.
I WILL HOPE THAT SOMEONE WILL POST HERE!