Jeff Moden (7/4/2016)

---

leehbi (7/4/2016)

---

We can create a model that works today but may be broke tomorrow.

The bigger problem is that in the BI domain we're quite far from the App...

No significant changes as far as I know. There's obviously been some tweaks, but no earth-shattering new features.

Not 100% sure what the question is, but sometimes you have no choice but to create System DSNs to help facilitate the connection.

The 32 vs. 64-bit driver issue could also...

There are some time-series calculations possible by using DAX in Tabular models, but as far as I know there isn't anything close to ARTxx or ARIMA available in that product....

Interesting...might have been an Excel nuance?

You could use the "AllMemberName" property of the hierarchy. See https://msdn.microsoft.com/en-us/library/ms174497.aspx

Hi Phil,

The best way is with a calculated measure, using a case statement to check if the sum (or aggregate) is less than zero.

It would also be possible to do...

It should be in the scheduled refresh section of the dataset. Click the ellipses next to the dataset name in the Power BI tenant and select "Schedule Refresh".

wigglo (6/3/2016)

---

Yes, I´m afraid so. The Enterprise Gateway works fine.

Is there a way to switch datasource...

You will most likely have to switch to the Enterprise Gateway. See https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise/%5B/url%5D

This happens sometimes when you delete cell contents out of an Excel file, instead of deleting the actual rows. It usually then appears as blank rows in any tool that...

leehbi (4/22/2016)

---

I favour agile approaches to BI. There is no better proof than the pudding 🙂

I still think even with user stories we can still run into problems. ...

leehbi (4/21/2016)

---

I'm thinking of how to handle the issue we see when a DW has gone live after lots of blood, sweat & tears, lets say the stack is SSIS,...

LAW1143 (4/19/2016)

---

it processes via an ssis task that I am admittedly not intimately familiar with.

another note, we are seeing memory starvation on the OS at the time of it processing.

Weve...

LAW1143 (4/19/2016)

---

ive considered that... when the cube is steady state, not processing, there is 500gb + free on the data drive. the total drive volume is 900GB.

we have metrics collected...