Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
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

Hi Markus,

 

i think you have to create a custom data connector.

https://github.com/microsoft/DataConnectors

 

Please give Kudos for support.

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

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.