Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Autmatice refresh from SQL server for desktop

I have a question about data storage and refreshing my pbix files. I currently have 4 different desktop files and they all have a few tables in common that are stored on a sql server. Each Bi file is...
Need Help
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey Anonymous ,

 

do you work with the Power BI Services (https://app.powerbi.com)?

There you can set the refresh of every file up to 8 times a day. You can also just have one file/data model and then base new reports on that data model.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I am working in Power Bi desktop and downloading from a SQL server we have. The connection seems very slow and refreshing takes a long time.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous,

    Can you please share more detail to help us clarify your scenario?
    For example:

    1. What type of connection mode are you worked on?

    2. Have you tried to use command tools to ping the network status between your device and database connections?

    3. Any advanced track or block policy enabled on your network route? (they may affect the status of the connections)

    Troubleshoot connecting to the SQL Server Database Engine - SQL Server | Microsoft Docs
    Regards,

    Xiaoxin Sheng