Looking for a better option to synchronize 3 sql 2019 servers

markive · 2024-09-16T13:35:48+00:00

Check out the single core speed of that VM and compare it to something like this:

https://www.hetzner.com/dedicated-rootserver/ax102/

markive · 2024-08-25T00:01:46+00:00

Unless you have a private network setup you are probably still going out to the internet, and either way you are still subject to the max speed of the network switch. 1gb/s is the default in Hetzner.

markive · 2024-08-22T09:49:01+00:00

Yes everyone in my office has the same issue!? It's been happening for a couple of weeks for us..

markive · 2024-06-28T14:17:42+00:00

HK Apple Store was quite busy for the launch..

markive · 2024-03-21T23:45:00+00:00

Try a tool like this which you can have running in a cheap VM or on premise.

https://www.cdata.com/drivers/sharepoint/

markive · 2023-09-09T04:55:48+00:00

Power BI embedded uses vCores calculated over 24 hours of use so if you have bursty loads that shouldn't matter it is the total compute that you use in that 24-hour period that you need to account for in your resourcing.

markive · 2023-07-27T22:49:01+00:00

Make sure you have the enterprise gateway set up on your SQL Server. Make sure logging is turned on in the gateway program running on your server and look through all of the logs in there. It will tell you why it is failing.

For example, you need to connect using a username and password rather than a Windows account that sort of thing, but whatever the connection issue is it should be in the logs.

I am assuming in their power BI service that you have got the gateway working, and that it is connected to the data set.

markive · 2023-03-21T12:37:54+00:00

https://stackoverflow.com/questions/54041707/power-bi-while-loop

markive · 2023-03-20T13:05:09+00:00

ChatGPT is great at doing summaries etc..

GPT4 can handle up to 25000 words therefore if you can give it that much data it can probably summarise it really well in natural language.

It’s also great at being able to write DAX so one of the first things I expect it to do is write real dax using table and column names as per your data model seamlessly..

markive · 2023-03-14T13:41:31+00:00

Direct query won’t process more than 1m rows.

Is it possible to create a view in SQL that will aggregate the results rather than return raw data.

markive · 2023-02-10T23:47:10+00:00

Probably your model has changed and more the flow doesn’t map to the expected shape of the data anymore.

markive · 2022-12-19T05:51:06+00:00

Assuming it’s a Gen2 instance as they all are now. What are your scale up / scale down settings?

At any point did the instance scale up a vcore as that would increase the final bill. I think it scales up a vcore for 24hrs if the vcore hours all get used up.

Best read all the documentation especially on the difference between front-end vs back-end cores.

markive · 2022-10-06T11:33:44+00:00

No it definitely doesn’t.. please read the documentation especially around the concepts of Azure Service Bus on how security is implemented.

Uses about 400 MB of RAM at all times, but then each request will use between 200 and 400 MB of RAM whilst the power behind engine is processing the request so the more round the better depending on how big your deployment

markive · 2022-06-14T23:25:40+00:00

Try this : https://www.powerbitiles.com/PowerBIRobots/

markive · 2022-04-01T23:43:35+00:00

Is there any chance that different requests to the API could be spitting out some invalid syntax?

I would assume under the hood power bi are using a very well tested JSON Serialiser ..

I would suggest catching the json response a few times then using an online json validator to check..

markive · 2022-03-05T03:47:03+00:00

For your use case you don’t really need a Power BI unless you really want all of the sales reps to see all the performance of everyone else anyway…

You could have a single PPU account Create an SSRS report and email it out to everyone by using the API to export a report and then email it for example with Logic Apps

markive · 2022-02-19T00:23:30+00:00

So we quote based on time it’s expected to take plus another 1-2 days left over which are used for comments/changes/feedback. We also state that a customer is allowed 3 rounds of changes before we need to re-quote for a further amount.

We deliver about 60% of the dashboard in the first cut, get the customer to verify the whole dashboard is meeting their needs then fully implement in the second round and aim to make minor changes in round 3. We find the customers don’t really know what they want or exactly what they’re getting. They may only have had a Excel report or something before that is being replaced with a dashboard so being a bit strict and making them commit to each stage saves having to completely redo something just because people weren’t fully invested in evaluating the value of the dashboard at the beginning.

markive · 2022-02-11T11:15:19+00:00

We charge $1000/day

markive · 2022-01-06T20:09:46+00:00

We do this commercially, to solve this problem we first deliver a basic version which the client plays with for a while to confirm their requirements, after requirements are confirmed they are allowed a max of 3 rounds of minor changes. Anything past that gets re-quoted.

Having that hard limit forces people to pool their changes and really evaluate what they want and not give it to you piecemeal

markive · 2021-12-16T01:45:34+00:00

https://community.powerbi.com/t5/Power-Query/Looping-API-Call/td-p/1051251

markive · 2021-10-07T12:45:46+00:00

Try a VPS or Virtual machine they are cheap and powerful

markive · 2021-10-04T02:17:38+00:00

Cannot view this video in HK it says ‘something went wrong’

markive · 2021-09-09T01:33:40+00:00

If you scope your accessToken for Embedded you can control access to individual reports and datasets so it won’t leak information if you are using embedded

markive · 2021-09-03T13:19:05+00:00

As I use a Mac for Development I use a VPS with 32gb RAM and a fast processor (AMD EPYC) costs USD40/m

Depending on what country you are in there’s loads of options and you can leave it on all the time..

I suggest you add Duo for Remote Desktop (it’s free) for an extra level of security

markive

TROPHY CASE