Power BI and Azure Table Storage

MK 1 Reputation point
2020-07-23T16:07:02.527+00:00

I have a question about how to best integrate Power BI with Azure Table Storage to visualize data and perform analytics in Power BI. I am directly connecting Power BI to Azure Table Storage but this is the issue I am facing:
--> There is no way to opt for 'Import' connection which makes it live connection by default. So whenever I make even a slight change in 'Edit Queries' it takes forever to refresh data even for 4-5GB data.

Is there anyway to avoid this? This slows down the process immensely. Is there any middle layer that you would suggest?

Azure Table Storage
Azure Table Storage
An Azure service that stores structured NoSQL data in the cloud.
156 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dave Patrick 426.1K Reputation points MVP
    2020-07-23T17:11:53.97+00:00

    Power Bi is not currently supported here on QnA. They're actively answering questions in dedicated forums here.
    https://community.powerbi.com/
    https://social.technet.microsoft.com/Forums/en-US/home?category=powerbi

    --please don't forget to Accept as answer if the reply is helpful--

    0 comments
  2. sadomovalex 3,626 Reputation points
    2020-09-07T15:01:04.327+00:00

    hello, one of the option is to implement middle layer by yourself via Azure function and then consume it in PowerBI: Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button.

    0 comments