cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Taniya Frequent Visitor
Frequent Visitor

I am getting the error message attached in below screenshot

I am having a pro liscence and my pbix file size is 300mb . 
Scheduled refresh gives the following error everytime
error messge.PNG

4 REPLIES 4
Super User III
Super User III

Re: I am getting the error message attached in below screenshot

@Taniya What is your data source? Depending on the data source you may have the option in Power BI Desktop to update the timeout, but that isn't on every source. Another option is to reduce the amount of information you are pulling in if it is un-needed to reduce processing time. What is the average duration to refresh when you do it in the Desktop?


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
Taniya Frequent Visitor
Frequent Visitor

Re: I am getting the error message attached in below screenshot

My data source is Microsoft Dynamics 365.
In desktop version refresh takes abot 30 minutes.
As you mentioned where do we get an option in desktop to increase the timeout capacity.

Super User III
Super User III

Re: I am getting the error message attached in below screenshot

@Taniya Connections that have the timeout dialogue are to SQL, I don't know if its on all db's. In terms of Dynamics, I would recommend you take a look at how you are pulling in the data. A big performance killer is ingesting or using the built in linked entities. These are the columns that have yellow values that let you connect to another entity. You want to keep the queries specific to 1 entity. When I've done this in the past it required refactoring some of the same business logic that was in Dynamics into Power BI (replace ids with names, etc). Removing these entity dependencies will increase your processing time exponentially. You can also use the new Diagnostics Tool in Power Query to determine which of your queries is performing the worst. Tools > Start Diagnostics


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
Taniya Frequent Visitor
Frequent Visitor

Re: I am getting the error message attached in below screenshot

Thanks Seth for you reply. I removed some of the unused columns from my report and now the the refresh is working fine.
Can you help me out with one more question i have does MAQ Grid Visual in Powerbi support Hyperlink and also how can we achieve Pagination with Tablular visual.

Bascially my task is to create a slicer which will give me list of page numbers (taking 50 data in one page)  and which can change dynamically with the filters. Currently i am using a table to generate series of pages accoring to my data but the problem is that table is not linked to any other tables and as such the page numbers are static in all case and does not change dynamically when filters are applied.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors