Forum Discussion

lmoranian's avatar
lmoranian
Regular Visitor
4 years ago

PowerBI Report Server Report Refresh

Hi,   Is there a way for reports on the web page associated with SSRSPBI to refresh the data?  I have reports using direct query and import and have scheduled refresh on the web page.  The refresh ...
SSRS. Power BI
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi lmoranian ,

 

Sorry I didn't notice you mention that you used directquery.

Not all Power BI Reports can have a scheduled refresh plan created on them. The following is a list of Power BI Reports that you Can't create a scheduled refresh plan.

  • Your report contains one or more Analysis Services data sources, which use a live connection.
  • Your report contains one or more data sources, which use DirectQuery.
  • Your report does not contain any data source. For example, data is manually entered via Enter Data or a report contains only static content like images, text, etc.
  • Your report contains dynamic data sources. For example, data from the report is used to dynamicaly build the name of a server, the name of a database, or a URL address to fetch contents. Only data sources that are detected when the report was uploaded can be refreshed.

For more you can refer to：

Power BI report scheduled refresh in Power BI Report Server 

 

If you insist on doing so, we recommend using Power BI Desktop & Power BI Service instead of Report Server.

Data refresh in Power BI 

 

Best Regards,
Community Support Team _ Caitlyn

lmoranian's avatar
lmoranian
Regular Visitor
4 years ago

Caitlyn,

Thank you.  Is there a difference between direct query and import?  You get to both options the same way.  The text you provided looks like it comes from the documentation.  I guess my problem is I don't understand exactly how the data needs to be set up for the refresh to work.

 

Thanks

 

Lynne

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi lmoranian ,

     

    Import Connection – Import Data Connectivity mode lets you import data into Power BI cache. Highly recommended to use Import connection when the data size is less than 1 GB and the data is not continually changing. You can import data with schedule refresh to get the latest data. With Import connection, you can take full advantages of the high-performance query engine.

    DirectQuery – DirectQuery Connectivity mode lets you connect directly to data. DirectQuery mode used to build Real-time or near real-time BI solutions when the data is changing frequently, and Data volume is very large. No data will be imported into Power BI. Instead Power BI will send queries to the data source upon building visual/interacting with visuals. Each query is restricted to return less than or equal to 1 Million rows.

     

    For more information，you may refer to ：

    Power BI Tips: Import vs Direct Query 

    Dataset modes in the Power BI service 

    About using DirectQuery in Power BI 

     

     

    Best Regards,
    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.