cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Data loading based on Table

Hallo fellow Power BI Users,

 

My Problem is that I want to design something like a template, where another user can select which data he wants to use and then build his report.

 

To make this problem clear i will give you an example:

 

Lets say we have a Table called KPI Meta table, consisting of ID, Name, Calculation Formula, ... In this Table all the Meta information of all the Users KPI are saved.

 

For each KPI the database has its own view, wich has a name like "KPI_VIEW_" &ID.. (KPI_VIEW_1, KPI_VIEW_2,...)

 

So based on the selected KPI we can just load the Data via

 

let

Source = FAKE.Database("fake.connection:76543", [Query="select * from FAKESCHEMA.KPI_VIEW_1"])

in

Source

 

What i want to archieve is, that when the user open this Power BI Desktop File he sees the KPI Meta Table, selects some IDs and then he clicks a Button and for each selected KPI a Query with the right Data is generated.

So the user can start to build his own report.

what I have tried so far:

* Create a parameterized Query. The problem is, that the user can only select 1 KPI, but the amount of Querys has to be variable

* Invoke this Query into the KPI Meta and expand the tables. Problem: I have a lot of KPIs and each Kpi View has its own Column Names, so i had around 20000 Columns afterward. I think it will be a little bit too messy for the user to select the right cols for the related KPI.

Thank you in advance and excuse my grammar, I'm not a native speaker

Markus

1 REPLY 1
mwegener Established Member
Established Member

Re: Data loading based on Table

Hi Markus,

 

i think you have to create a custom data connector.

https://github.com/microsoft/DataConnectors

 

Please give Kudos for support.

If I answer you question, please mark my post as solution, this will also help others.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 434 members 4,124 guests
Please welcome our newest community members: