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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
reynold522
Helper II
Helper II

what is the most efficient way to update table

We have a lot of IoT devices uploading data to cloud. 

There several tables

1. Tracking table(overview table): IoT ID, installation data, region, purpose etc.

2. Data table 1: IoT ID, Timestamp, data1, data2 etc. 

3. Data table 2: IoT ID, Timestamp, data1, data2 etc. 

4. DimDate

 

I linked  IoT ID of tracking table with all data tables and data from DimDate table with all toher data tables. 

 

My question?

previously, if IT department update one data table/tracking table e.g., add one or more columns, I usually delete old table and load the new table. however, I have to do relink and copy past all measures from old table.

I use directquery in my Power Bi Dashboard. is there any new method to update tables? minimize the effort to update?

Thanks in advance!

 

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Instead of connecting to the tables in your data source, create views and connect to these views.  That way you can shield Power Query from the table structure changes.

View solution in original post

4 REPLIES 4
lbendlin
Super User
Super User

Instead of connecting to the tables in your data source, create views and connect to these views.  That way you can shield Power Query from the table structure changes.

Thank you very much. 

 

It is well known in snowflake to create view. 

 

as you talk about create view in power bi, is it via summerize function?

Usually you create these views in the Power Query source (the upstream system), likely a SQL Server database .  Power Query queries also act as a type of abstraction/view from the perspective of the Power BI data model.  in DAX you can create calculated tables via SELECTCOLUMNS or similar functions.

Thank you for help

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors