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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
eddydm
Advocate II
Advocate II

Source different in Devellopment and Production

I hae an excel file with a sheet  A and some data in it.

I have made a powerbi presentation of that data.

After publishing the powerbi file, I'v added more and more data in this excel-file. the refresh of the data in the service is working well, but it takes a lot of time (let's say 20minutes).  I don't see at this moment how I can optimize the calculation.

 

Now I have to change the type of powerbi presentation. (other kind of graphics, additional filtering, new tabs, ... à

I'm doing this adaptation in my devellopment environment and sometimes the file has to be refreshed. At that time I have to wait 20 minutes.

 

How can I devellop with a smaller source file (let say sheet B in the same excel file, smaller number of rows, but the same structure of sheet A), adjust my pbix-file, deploy it and then tell to the system that he need to use the sheet A.

 

Thanks in advance for any idea.

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Typically you would do something like that using a query parameter.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

Typically you would do something like that using a query parameter.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

I was thinking in the same direction 🙂

I hoped there was another way because I am new to the principe of query parameters

Meanwhile I'v figured it out how I can solve this issue!

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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