Hey guys,
I hope this is the right category for this question.
I use different tables from one datamart on Azure Databricks. The datamart only gives new data, when all tables are fully loaded.
When I reload all tables one for one in Power BI, they all give me the new data. But when I refresh all tables at the same time (in Power BI desktop and also in the Power BI service when I reload the dataset), all tables get refreshed BESIDES one. It does not get an error and that table is always the same one. Sometimes it goes well, but a lot of the time that table won't load with the rest. When I choose to reload only that table, it works fine. Also, when I query on databricks, that table has the new rows. So the data is avalaible, but just won't come with the full refresh in Power BI.
To notice that it happens, I have put a visual in my report that counts the rows of a specific ID that needs to be the same in the tables. In that way, my stakeholder will notice it and I can manually refresh that one table. But of course it just needs to be able to automatically refresh all tables.
Is this a common issue? Does anyone recognise it and knows how I can fix it?
