Search found 5 matches

by ghentt
Thu Feb 11, 2016 7:14 pm
Forum: General
Topic: SSRS compatible with Power BI
Replies: 1
Views: 1534

SSRS compatible with Power BI

Hi
Can we use Power BI to attached to a local SSRS server as our data is to sensitive to use the public cloud.
Are there any resources to guide us down that path

cheers
Tony
by ghentt
Fri Oct 10, 2014 10:27 pm
Forum: PowerPivot/DAX
Topic: SQL statement, Union all
Replies: 4
Views: 2439

Re: SQL statement, Union all

Hi Guys Thanks for the replies, hopefully I will get time to play this weekend. The reason I asked about SQL as it was mentioned in the Contextures website ie SELECT [EastSales$].* FROM [EastSales$] UNION ALL SELECT * FROM 'C:\_TESTWestSales.xlsx'.[WestSales$] when they were discussing merging 2 ide...
by ghentt
Wed Oct 08, 2014 7:27 am
Forum: PowerPivot/DAX
Topic: SQL statement, Union all
Replies: 4
Views: 2439

SQL statement, Union all

Hi I have 10 files with 600K+ rows i need to merge into one file for powerpivot. I could go down the dos box road with CSV files with no headers or use a SQL statement, to create a union query. My question is, can you run the "Union All" statement inside a loop to pick up all the files. As...
by ghentt
Wed Oct 08, 2014 7:16 am
Forum: PowerPivot/DAX
Topic: Calender table
Replies: 2
Views: 1264

Calender table

Hi
Does anyone have a link where I can download a calender table.
thanks
tony
by ghentt
Tue Sep 23, 2014 10:50 pm
Forum: PowerPivot/DAX
Topic: Import data from many workbooks
Replies: 1
Views: 1044

Import data from many workbooks

Hi Fellow Power Pivotors Help needed to find the best solution I have 3 years of data on a server, each year has 4 shared workbooks with 3 monthly worksheets in each workbook. Many staff have access to the files for data entry and the data for the last three months is changed frequently as the finan...

Go to advanced search

cron