SSRS - Power query connection, refresh only PQ

zabudnem_heslo

New Member
Joined
Oct 3, 2019
Messages
4
Hi guys,
I managed to create connection from SSRS to power query, but our reports are slow and based on connection method I need to refresh PQ queries after Power Pivot connection,
is there some macro/ option how to do it without clicking at every query manually? And ideally without refreshing Power Pivot connection again as it takes a long time.

Here is the step-by-step manual for SSRS -> PQ connection, hope it will help, as I couldn't find anything similar online

SSRS => PowerPivot => Power Query

  1. Atomsvc datafeed, import from other sources in power pivot
  2. Basic authenthification
  3. Close Power Pivot
  4. Click on data => Existing Connections
  5. Double click on DataFeed
  6. Load to sheet
  7. Add to Power Query as Table/ Range
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
4,714
I don't know your source data but in PQ is more services or from link to table in atomsvc, even other sources ;)
 

zabudnem_heslo

New Member
Joined
Oct 3, 2019
Messages
4
Source of my data is sql reporting services, but i cannot get authentificated, when I try it through Odatafeed
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
4,714
so this is a problem with authentication not with data

maybe try any SQL service (eg. sql server database)

there is no any golden solution so you need try and try and...
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,089,961
Messages
5,411,533
Members
403,377
Latest member
chrisj2812

This Week's Hot Topics

Top